Discussion board where members can get started with Qlik Sense.
I have a variable and like to be able to switch between Weeks and Months. For some reason it is not working. Is this a bug or some other reason?
if(vTimePeriod='MonthSelected',[Ship Month],[Order Month])
But this one isn't working
if(vTimePeriod='MonthSelected',[Order Month],[Order Week])
Go to Solution.
What I would is as follow:
Create an inline table :
load * inline [
The create a variable :
vDim = if(DimID=1,YourMonthField,YourWeekField) :
And in your chart, as dimension, choose : $(vDim)
And add you Dim field as a filter
Hope you're satisfied...
What do you mean by switching between Weeks and months? You want to have 2 dimensions per graph? and be able to alter btwn them on selection?
I have a variable with two options, Weeks and Months.
I want a chart or table with a dimension and depending on the choice of variable it needs to show weeks or months.
For a chart, you won't need to create variables for that, you only have to add an alternative dimension:
For example :
Alternative Dimension: Region
In your case: dimension: Month, alternative : week
And then you simply click to choose what dimension you wanna work with :
I know alternative dimensions , but for my case I need it as a variable. So any help with a variable would be great!
That works indeed. While a variable switch didn't work, the inline dimension made the difference. Strange, but thanks!