Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie777
Partner - Creator III
Partner - Creator III

Switching YTD and Month measures by a slicer in a chart

Hi 

I'd like to switch YTD and month measures by a click of a slicer in a chart.  At the moment, I only have a multi-year YTD chart like below but instead of using up double the real estate space by creating a separate month view chart, I'd like to be able to switch between the YTD and month measures by a click of, say a slicer.  I am a Power BI user and this can be done using a switch measure in Power BI, but I am new to Qlik Sense, and am wondering how I can achieve a similar effect in Qlik Sense.  

Sakiko_0-1622957996795.png

Thanks for your help.

1 Solution

Accepted Solutions
Vegar
MVP
MVP

The built in function for switching between different measures in Qlik Sense is called Alternate Measure. Take a look at this Qlik Design blog post.

https://community.qlik.com/t5/Qlik-Design-Blog/Alternate-Dimensions-and-Measures/ba-p/1462903

View solution in original post

2 Replies
Vegar
MVP
MVP

The built in function for switching between different measures in Qlik Sense is called Alternate Measure. Take a look at this Qlik Design blog post.

https://community.qlik.com/t5/Qlik-Design-Blog/Alternate-Dimensions-and-Measures/ba-p/1462903

Newbie777
Partner - Creator III
Partner - Creator III
Author

This is great!  Thank you for your answer.  I created two measures for YTD and Month to switch between, but both are being shown as "Expenses" as I used modifier "Accumulation" for YTD chart.  I'd appreciate it if anyone can point me to the place where I can rename the measure for alternative measures.