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: 
sravankv
Partner - Contributor III
Partner - Contributor III

Visualization | Issue in Showing MOM Trend Result

Hi All,

 

I having a challenge to show MOM Count on Bar Chart.

Issue: Selected Month is showing correct Count. But, previous months are showing wrong result.

Ex:  I have 3 months data and i need to show count(distinct GID) where Count(distinct EID)>2.

Count(DISTINCT{<Month={"<=$(=max(Month))"},GID={"=count(distinct EID)>2"}>}GID)

when i used above query the result are 

sravankv_0-1638175945526.png

instead of:  small correction 1, 1, 3(Jan: GID 200 is having 3 dif EID's, Feb: 200 is having 3 dif EID's and Mar: all 3 GID's  having 3 dif EID's.

sravankv_0-1638192145718.png

 

I am not able to aggregate count's based on Month.

Sample Data:

Month GID EID
31/1/2021 100 101
31/1/2021 100 102
31/1/2021 200 201
31/1/2021 200 202
31/1/2021 200 203
28/2/2021 100 101
28/2/2021 100 102
28/2/2021 200 201
28/2/2021 200 202
28/2/2021 200 203
28/2/2021 300 301
28/2/2021 300 302
28/2/2021 300 302
30/3/2021 100 101
30/3/2021 100 102
30/3/2021 100 103
30/3/2021 100 104
30/3/2021 200 201
30/3/2021 200 202
30/3/2021 200 203
30/3/2021 200 204
30/3/2021 300 301
30/3/2021 300 302
30/3/2021 300 303
30/3/2021 300 304

 

Appreciate your support and Thanks in advance..

Labels (1)
2 Replies
chrismarlow
Specialist II
Specialist II

Hi,

Any set analysis applies across all of the values by dimension,  so you can't filter differently by month like that.

I think you could try IF & AGGR similar to the below ... I don't know if you really need the max(Month) piece, but you can in theory combine;

20211129_3.png

Cheers,

Chris.

sravankv
Partner - Contributor III
Partner - Contributor III
Author

@chrismarlow  Thanks for your response.

But, it's a trend chart and I have to show MoM comparison from the month selected to previous months.

So, that's the reason I used <=$(=max(Month))