Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Hope everyone is doing good!
I have a requirement where I have to change dimensions based on variable selection.
I have three buttons and one variable vTimedimensionselected, for Button1 variable value is 'Month, For Button2 variable value is 'Quarter' and for Button3 variable value is Year. I'm using below calculation as dimension
if(vTimeDimensionSelected = 'Month', [Month Start],
if(vTimeDimensionSelected = 'Quarter', [Quarter Year],
if(vTimeDimensionSelected = 'Year', [Year Start]
)))
In Qlikview it's working fine but in Qliksense it's not working. Can you help me on this?
Regards,
Chiru
Hi @chirums1 ,
Instead of having the If condition, directly pass the variable. Also, inside the button you can declare the field value as "Month Start" or "Year Start" or "Quarter Start"
Please find the attached QVF to change the dimension based on the selection value in button of your scenario.
not working means ? what is the issue?
what is the result you can see in dimension area below the condition?
and what is the variable value and how you defined ?
Hi @chirums1 ,
Instead of having the If condition, directly pass the variable. Also, inside the button you can declare the field value as "Month Start" or "Year Start" or "Quarter Start"
Please find the attached QVF to change the dimension based on the selection value in button of your scenario.
sorry. i dont have qliksense installed on my machine.