Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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