Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I've one list box called Yardstick and it contains R3M, R12M,QTR and YTD(PFB for your reference)
My requirement is in text object, only Maximum bucket should display If I select QTR.
So here my desired output should be Apr'18-June'18. I've tried with below expression but no luck.
Aggr(Max(RollingPeriodString),Yardstick)
would someone can suggest how do I achieve this requirement.
Appreciate your effort.
Thanks
The max value doesn't work on string values. Perhaps you can turn your RollingPeriodString values into values with both a numeric value and a string display format value using the Dual() function.
Do you not have the actual date field ? Use that instead. I am assuming you created the string field afterwards.
Date fields are duel, meaning numerical functions such as Max can be used.
Hi Gysbert,
Thanks for the response.
Would you be able to elaborate this in detail.
I've tried with dual but didn't work.
Please suggest if have any other alternatives.
See these blog posts:
Dual & Exists – Useful Functions
If that doesn't help you solve your problem the please post a small qlikview document that illustrates the problem.
Thanks Gysbert for the response.
I've tested with Yardstick-QTR
Yes Almost reached in filter and In text object I have taken Max(RollingPeriodString1) and its displaying 3.
But here my desired output should be Apr'18-Jun'18.
Please find the below sample script along with dual and correct me if I'm anything wrong.
Before:
After changes with dual:
Look forward your quick response.