Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator II
Creator II

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
Specialist II
Specialist II

How about,

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

Capture.PNG

View solution in original post

2 Replies
jwjackso
Specialist II
Specialist II

How about,

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

Capture.PNG

View solution in original post

shilpan
Luminary Alumni
Luminary Alumni

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