Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Aggr() function

Hi guys,

Please help me on this function:

I have a table as shown:

Date  group  plan_checked  visit_checked

Mon.    1                  0                      0

Mon.    1                  0                      0

Mon.    2                  1                      1

Tue.     3                  0                      0

Tue.     4                  0                      0

Wed.    5                  1                      1

I want to count the number of distinct Date&Group with plan_checked=0 and visit_checked=0. The result should be like:

Mon.    1   

Tue.     2

Wed.    0

My function is:

SUM(IF(Aggr(SUM(ItemChecked)+SUM(MSChecked)+SUM(TPChecked),[Date]&Customer)=0,1,0))

It doesn't work.

Thanks for help!

1 Solution

Accepted Solutions
jwjackso
Contributor III

Re: Aggr() function

How about,

=Count({<plan_checked={'0'},visit_checked={'0'}>} DISTINCT group)

Capture.PNG

2 Replies
jwjackso
Contributor III

Re: Aggr() function

How about,

=Count({<plan_checked={'0'},visit_checked={'0'}>} DISTINCT group)

Capture.PNG

shilpan9166
Contributor II

Re: Aggr() function

Use Date as dimension and Count({<plan_checked={0},visit_checked={0}>} DISTINCT group) as expression