Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a field where the values are stored as
I want to find the max value in the front end. ,and its should be displayed in 'YYYY-Q' format
Any tips ..as they are interpreted as string values
Go to Solution.
return the latest quarter?
But it might be good to interpret your values as duals, so you can use Date /Time functions on them.
edit: Interpreting like
Dual(Quarter, QuarterStart(Makedate(Left(Quarter,4)),Right(Quarter,1)-1)) as QuarterDual
View solution in original post
wot ever you decide, always go back to your base unit as users are fickle, get it working @ the base unit, the rest should fall into place
Thank you swuel, it works!
but the only problem is in the textbox it shows the numberic values I want to display as YYYY-Q
How can it be done
Is this the only way
Yes, keeping the text format of a dual value when e.g. using Max() might get annoying.
In your specific case, you should be able to use MaxString(Quarter) or MaxString(QuarterDual)
In other cases, you might need to reformat the value.
Wow!,I never knew there about maxstring() function .