how to find quarterend value in qlikview

[sanjeeva_279]

Hi All,

I need to report values based on lastday of 5 quarter 

i am getting extra values with Firstsortedvalue function,could you please let me know how to value based on quarterend

max(date) is not quarter end it's in between ,so i am not able to find the values,thanks

[Brett_Bleess]

Check the following Design Blog post, hopefully it may be along the lines of what you need or can use for the use case:

https://community.qlik.com/t5/Qlik-Design-Blog/Using-the-Ceil-Function-to-Create-a-Quarter-Field/ba-...

This way you can just select the Quarter etc. I think, sorry if I am totally off-base with things.  You may need to attach QVW file in order to get further suggestions, and if you have sensitive data, you can use the Settings\Document properties\Scrambling tab to scramble those fields prior to posting.

Regards,
Brett