python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - qlikview

Qlikview: Problem of the average duration of the most used subscription modality

Be a subscription video streaming service. There are 3 subscription modalities, A, B, C. You want to calculate the average duration of the modality that has the highest number of subscribers per month...
test-img

Mr. Baldan

business-intelligence

qlikview

Votes: 0

Answers: 1

Latest Answer

If you are using Month as a dimension on a chart, you can use the expression: =FirstSortedValue( Aggr(Avg(Duration), Msuscription, Month), -Aggr(Count(user), Msuscription, Month) ) This is so...
test-img

Professor Pantsless

How to select values in one table based on variable from another table in QlikSense?

I have two tables, They are linked by CustomerID. I have created a variable input Sales = StoreSales and I want to display a table with the relative frequency of the occurence of the stores based on ...
test-img

user42

data-visualization

visualization

qlikview

qliksense

qlik-expression

Votes: 0

Answers: 1

Latest Answer

Take a look at the table I've created for you. Your expression is =if(round([StoreSales])>=$(Sales), StoreName) returning nulls because you are not telling it what to do with the true values. A cou...
test-img

The Budac

How to create a range picker for a variable in Qlik?

I'm new to Qliksense and I would like to select and visualise all datapoints in my table based on the value of a variable called NoOfPersons, similar to the date-range picker. How can I do this? I hav...
test-img

user42

data-visualization

visualization

qlikview

qliksense

qlik-expression

Votes: 0

Answers: 1

Latest Answer

Under the Custom Objects the Qlik Dashboard bundle select the variable input object Then under the variable options select the slider option I don't know how to make it look like your example but it...
test-img

The Budac

Can we have and manage QlikView User in Sql and handel their access to special sheet?

I want to have and manage all QlikView user in SQL instead of having them in active directory. I do not want to create one by one in qlikview Is there any way to use all user in sql and connect them i...
test-img

fahime abouhamze

sql

security

active-directory

dashboard

qlikview

Votes: 0

Answers: 1

Latest Answer

Haven't done it myself but think that these things are achieved via Directory Service Connectors/Directory Service Providers (DSP) This document (docx) explains how to setup DSP with MS SQL, Excel or ...
test-img

Stefan Stoichev

Posts

Questions

Blogs

Jobs