Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
vCurrOrders=Sum{{<Year={$(=max(Year))}>}distict OrderID)
vPrevOrders=Sum{{<Year={$(=max(Year)-1)}>}distict OrderID)
KPI expression:
num((($(vCurrOrders)-$(vPrevOrders))/$(vCurrOrders)),'##0.0%') is not working,
It worked in Qlikview with = sign before num, but it is not working in QS. I don't know why.
Please help me
You either mark your response as correct or mark the thread as assumed answer. This is how you close a thread
Does your variable definitions include = sign before the expression or not?
When I copied and pasted from QV app, it is not working, when I typed the same code manually, it worked
Thankyou
Great, please close this thread if your problem is resolved.
Best,
Sunny
How to close the thread sunny
I don't find anything to close the thread in the link you sent
You either mark your response as correct or mark the thread as assumed answer. This is how you close a thread
Oh, Ok Thankyou