Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to display top 3 chart based on month selected

I have a request to create 3 bar charts on a tab. My table has branch No.,  Cancellatation code, Cancellation reasons, ReportMonth and Amount Canceled. Users wants the chart to always display the top 3 cancellation reasons by branches.  Is it possible to do it so that monthly the charts changes  to shows current months top 3 cancellation reasonscancellation reasons. I am using branch and Cancellation reason as dimension and for my expression am suming the amount of cancelled. If user select a month the should be able to see the top 3 reasons charts and those should chart by month(top 3 reasons will vary by month). Any idea?

CaptureReason.JPG

0 Replies