topic Re: Set analysis count all data ignoring selectors. in QlikView

Set analysis count all data ignoring selectors.

Anonymous — Tue, 10 Jul 2018 05:09:23 GMT

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.

Chanty4u — Tue, 10 Jul 2018 05:15:05 GMT

count({1}Type)

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

Anonymous — Tue, 10 Jul 2018 14:46:35 GMT

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 — Tue, 10 Jul 2018 15:08:31 GMT

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

Chanty4u — Tue, 10 Jul 2018 15:08:59 GMT

May be this

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

ogautier62 — Tue, 10 Jul 2018 15:31:45 GMT

I think you need something like this :

Type in dimension,

and in expression :

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

regards