Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmac1971
Creator III
Creator III

Counting based on 3 cases

I have 3 separate lists of data and I want to check how many items exist on all three lists.

I thought this might work :

=aggr(count(Distinct Item) LIST)

But not getting anywhere with it?  If I then wanted to count the number on specific lists, lets say only those items that appear on list 1 and 2, where the price is different and then another count where the price is the same how would you achieve it.

10 Replies
tamilarasu
Champion
Champion

Seems comma is missing.

=Aggr(count(Distinct Item), LIST)

MayilVahanan

hi

Can you provide some sample data with your desired output.

Its easy to verify and resolve it

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
its_anandrjs

Can you share your qlik file.

Regards,

Anand

dmac1971
Creator III
Creator III
Author

Cant share Qlik file, surprised that people even ask this?

dmac1971
Creator III
Creator III
Author

Sorry I have a comma in my expression already, typo on here.  Expression will only work when List has filter to one single List name.  I need to see how many items exist on all three lists.

Anonymous
Not applicable

count(Distinct Item), LIST)+count(Distinct Item), LIST)+count(Distinct Item), LIST)

luciancotea
Specialist
Specialist

Depending on the object used to display the value, you can have different approaches. To display on a chart and see the total:


=SUM(Aggr(count(Distinct Item), LIST))

luciancotea
Specialist
Specialist

A standard support procedure is to replicate the problem. Try to recreate it in another document using dummy data.

dmac1971
Creator III
Creator III
Author

Lucian, many thanks, this works, I was missing the initial SUM.  If I now wanted to do the same calc but base the result on another field but only if greater than zero?  Say Price?