Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I set the current time (line) in a graph in Qlikview ?
Correction:
It should be this:
Month(today()) + Day(today())/Day(MonthEnd(today()))
Good luck.
I have a QlikView file where I created a line graph. On x-axies I have Quarters and on Y-axies percentages. Quarters on x-axies are now in this order:
Q1/12, Q1/13, Q2/12, Q3/12, Q4/12
I am using the following expression:
=left(Fiscal_Quarter,2) &'/'& right(Fiscal_Quarter,2)
I want Q1/13 should come to the end.