Using BUTTON to select YTD, MTD, QTD for a single chart

[thakurdagautam]

I am using Qliksense and i wanted to use the BUTTON in the charts to directly toggle between YTD, MTD, so on for a single chart. ANy idea how i might do so?

[abhijitnalekar · Accepted solution]

Hi @thakurdagautam ,

You can do this using button or variable input component.

Pass the value to the variable through the button and use the expression in the chart accordingly.

[abhijitnalekar]

Hi @thakurdagautam ,

Please do the steps as below.

1.  drag Input varaiable to the sheet

2. in input variable property select Buttons

3. set values for the buttons as below

 your input variable will look as below

4. set the variable for the input variable 

Once this is set you can change the measue expression in the line or bar chart.

assuming that your YTD and MTD expressions are ready with you. 

[thakurdagautam]

Thank you very much. Will attempt

[Nisha25696]

Can u please add the demo expression for YTD and MTD sales also

[abhijitnalekar]

MTD : Sum({<Date={">=$(=Num(MonthStart(Max(Date))))<=$(=Max(Date))"}>} Sales)

YTD : Sum({$<Year=,Month=, Date={'>=$(=YearStart(Today()))<=$(=Today())'}>}Sales)

Hope this help