Discussion board where members can learn more about Qlik Sense App Development and Usage.
This is my data set
I wanted to get the last col to be a distinct count for the month. which would be 7 for JAN and 6 for FEB.
But you can see from the results I only get 7 for the 1st row, and 6 for the last row.
Not understanding why it is blank for the 2 middle rows.
Can you help to explain what I should do? and why is my logic wrong? Appreciate your inputs.
The effect I wanted is
Go to Solution.
Count(DISTINCT TOTAL <Channel, Month> Qty)
Aggr(NODISTINCT Count(DISTINCT Qty), Channel, Month)
This is great! Thanks Both works.
I understand Count(DISTINCT TOTAL <Channel, Month> Qty).
Can you explain why Aggr(NODISTINCT Count(DISTINCT Qty), Channel, Month) has to use NODISTINCT?
I am counting the number of rows. So I am wondering why NODISTINCT works but not DISTINCT.
Before I try to explain this myself, see if one of these two threads answer your question
What NODISTINCT parameter does in AGGR function?
Qlik Tips: No nodistinct
Thank you! It definitely helps a lot!