This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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])
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...
View solution in original post
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!