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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-06-24 03:53 PM

Suggestion on building dynamic revenue matrix chart

We have a Revenue Matrix straight table chart built using QlikView which gives revenue across products and countries. The numbers shown are YTD and the background color for cell is calculated based on % difference between YTD vs Prev. YTD

Now our users are looking to expand this chart one step further. They want to have an ability to select the comparison period by themselevs. It could be any quarter vs any quarter, year vs year or any month vs any month...

I am thinking of designing it this way... provide 3 buttons on top of the page - Year, Quarter, Month. If they select Quarter, 2 additional lists will appear both having all possible quarters to choose from. Then there will be a button as Refresh which will call a macro to change the expression used in revenue matrix chart to change the comparison criteria to selected quarters. Similarly there will be different lists for year and month..

Before I proceed further, wanted to check if there is any better way of designing this type of feature? Would appreciate any comments..

Thanks!

407 Views
0 Likes
0 Replies