Dynamic X-axis based on filter selections.

[Divyanshu]

Hi all,

I want my line chart's X-axis to change dynamically on the basis of a 'Time-Period' filter selection. How to achieve in Qlik -> the dynamic chart where the x-axis would update based on dropdown selection (if current qtr, then x-axis would be q1, q2, etc. and if YTD, it would be 2021, 2022 .. basically all years).

[Or · Accepted solution]

If(SelectionField = 'current qtr', QuarterField, YearField) in a calculated dimension, assuming these are the only two options. If there's more options, add if() statements. If you don't already have a SelectionField, you can create one using

LOAD * INLINE [

SelectionField

current qtr

YTD ];

[Divyanshu]

Thanks for the reply. It works perfectly now.