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: 
Not applicable

Display based on number of rows

I currently work on the calculation of the sales as following and attached:

I like the report to only show the sales if the number of transactions is more than 3 times. For example, HongKong only has sales of 3 times so that it shouldn't appear in the report. The ideal report should like following:

I assume that count() function should be used to get the number of rows. If number of rows is less than 3, don't display. Tried couple of times and still couldn't figure out.

Please help and thank you in advance.

1 Solution

Accepted Solutions
sunny_talwar

Does this work?

YearMonth Dimesion would be: =If(Aggr(Count(Date), YearMonth)> 3, YearMonth)

Best,

S

View solution in original post

5 Replies
sunny_talwar

Is this what you are looking for? PFA

Country will be a calculated Dimension as follows :  =If(Aggr(Count(Date), Country, Store, YearMonth) > 3, Country)

Best,

S

Not applicable
Author

Thank you so much for your reply. I should say that I put a bad example there

The file should actually be like following and attached.

And the final report should be

I tried your method to put calculated dimension for YearMonth as YearMonth=If(Aggr(Count(Date), Country, Store,YearMonth) > 3, YearMonth) but failed.

Please help.

sunny_talwar

Does this work?

YearMonth Dimesion would be: =If(Aggr(Count(Date), YearMonth)> 3, YearMonth)

Best,

S

Not applicable
Author

Thank you so much. It works perfectly. I also forgot to check the 'Suppress when value is null'.

sunny_talwar

No problem.

Best,

S