Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis count all data ignoring selectors.

Hello,

I want to count all data by type in the table, no matter if I select month or quarter or date.

i.e. if i select month 3, the count must be 10 (Type 1). and 9 for (Type 2).

      if i select quarter 2, the count must be 10 (Type 1). and 9 for (Type 2).

     if i select date 01/03/2018-03/03/2018, the count must be 10 (Type 1). and 9 for (Type 2).


Thanks for your help.

DATOS1.PNG

5 Replies
Chanty4u
MVP
MVP

count({1}Type)

or

count({<Year=,Month=,Date=.Quarter=>}Type)

Anonymous
Not applicable
Author

Thank you Chanty 4u‌ , and if I want to add a condition "and" something like this:


count({<Year=,Month=,Date=.Quarter=> (and valor>0)}Type)


Thanks

neelamsaroha157
Specialist II
Specialist II

count({<valor={">0"}, Year=,Month=,Date=.Quarter=>}Type)

Chanty4u
MVP
MVP

May be this

count({<Year=,Month=,Date=.Quarter=,valor={">0"}> )}Type)


ogautier62
Specialist II
Specialist II

Hi

I think you need something like this :

Type in dimension,

and in expression :

count( {1<Type = P({$})  >} type)

regards