Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Does this work?

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

Best,

S

View solution in original post

5 Replies
Highlighted

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

Highlighted
Not applicable

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.

Highlighted

Does this work?

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

Best,

S

View solution in original post

Highlighted
Not applicable

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

Highlighted

No problem.

Best,

S