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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamically change the axes in a chart

I was using this sales vs date chart with Daily Sales on the Y-axis and Dates on X-axis.

At the top, I have filters to choose the start and end dates. But if I set the filters in a way that the date difference between the start and end date in 30+ days, then it becomes cumbersome to read it properly. Is it possible to calculate the difference of selected date & store it in variable and  if variable < 15 days then, show graph_1, if variable >15 & < 30, then show graph_2, else graph_3 where

graph1 - will always shows date wise sales

graph2- weekwise

graph3- monthwise
Please help.

10 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Thanks for sharing Bill.