Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Seems comma is missing.
=Aggr(count(Distinct Item), LIST)
hi
Can you provide some sample data with your desired output.
Its easy to verify and resolve it
Can you share your qlik file.
Regards,
Anand
Cant share Qlik file, surprised that people even ask this?
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.
count(Distinct Item), LIST)+count(Distinct Item), LIST)+count(Distinct Item), LIST)
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))
A standard support procedure is to replicate the problem. Try to recreate it in another document using dummy data.
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?