Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
brcovenantpp
Contributor
Contributor

Top 6 By Month in Chart

I have a bar chart with 1 dimension and 1 measure, by month. I want to show the top 6 dimensions(Total sales) for each month. I know you can use the top/bottom buttons with an expression defining the amount you want. Want I want to try to do is conditionally format dimensions that weren't in the previous month's top 6. So if a new dimension enters the top 6 in June, and wasn't in the top 6 in May, it's bar is colored red. Not sure if this can be done, but any help would be greatly appreciated. Thank you. 

Labels (1)
2 Replies
sidhiq91
Specialist II
Specialist II

@brcovenantpp  Could you please provide some data and also the expected output that you are looking for.

brcovenantpp
Contributor
Contributor
Author

brcovenantpp_0-1659020447142.png

This is one of my charts. What I'd like to do is, if one of the columns isn't present in the previous quarter's top 6, add a conditional format that would color the bar red to indicate it's new to the top 6.