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: 
PeytonClara
Contributor
Contributor

Switch between Month, Quarter and Year?

I have a dashboard with various combo charts showing bars of different measures by Month as well as a 6 bar moving average line. My requirement is to allow users to switch to Quarter or Year, based on a radio box selection (single value radio box via Field UI extension, set to single value).

Any help how to do this in Qlik Sense please?

EDIT for clarity:
If users click to view by Quarter, the horizontal axis should change to Year-Quarter and charts should display for 6 quarters, 1 bar per quarter. Moving average line should be 6 quarters' moving average.
If users click Year, horizontal axis should be year; charts should display 6 years, 1 bar per year. Moving average should be 6 years' moving average.

1 Reply
QFabian
MVP
MVP

Hi @PeytonClara , i can see two possible options:

1.- Master items

Create a master dimension, with drill-down, and use it in our chart as dimension:

QFabian_0-1614617387148.png

2.- Create your chart with one normal dimension, and two Alternative dimensions :

 

Then you can change the dimension in your chart when you are navigatingQFabian_1-1614617489231.png

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.