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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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.