topic Re: Ignore Selections in QlikView

Ignore Selections

achitreskyitgroup — Fri, 08 Nov 2019 17:39:10 GMT

Hi All.

Is it possible to ignore the selections?

I have to find average users per Day, week, month etc.

This is my expression: =Floor(Avg(Aggr(Count(DISTINCT([UserName])),Day)))

When I select User class in the Dimension List box I get

User Class | Daily Active Users

Total | 1584

CLIENT | 1588

USERS | 1583

But when I select the USERS it shows:

User Class | Daily Active Users

Total | 66

USERS | 66

which is correct.

how do I ignore the selections to always show the accurate value.

Re: Ignore Selections

sunny_talwar — Fri, 08 Nov 2019 17:49:51 GMT

Which of the two is showing the correct numbers? What selection did you make when you see the 1st table and what selection did you make to get the second table?

Re: Ignore Selections

docpuddu — Fri, 08 Nov 2019 17:51:34 GMT

Hi,

to ignore selection you should use

set identifiers

1 - Represents the full set of all the records in the application, irrespective of any selections made.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

HTH.

Ciao,
/Andrea

Re: Ignore Selections

achitreskyitgroup — Fri, 08 Nov 2019 17:52:22 GMT

So When I select User Class from the Dimension List and Daily Active User from the Metrics. I get the First table. When I click on Users in the Table I get the second table