Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a line chart that displays the Date value Vs Order Revenue .
Date value depends on the toggle 1 or 2 , Toggle 1 Order date and if selected Toggle 2 Order shipped Date
I have created a variable selectiontype, and i have described it in my measure .
I am not able to implement it in my x axis/ dimenion.
i need something like below in dimension expression
if selectiontype=1, Month([Order date]), Month([Shipped Date])
Pls let me know
Thank you
hi
assuming your expression is the same for both date
than the easy way will be
to create the order data as one dimension
and add the order shipped date as alternative dimension then the user can switch between them using qlik sense native capability
Strange thing is
When I use if(vSelectionType=1, Month(OrderDate]), Month([Shipped Date]) in the Dimension expression directly- first criteria works doesnt work for second .
But When I create a new dimension using above expression, it works for second criteria that is vSelectionType=2 and not when it is 1.
I want it to work on both cases.
Any help is appreciated.
Thank you