how to find quarterend value in qlikview - Qlik Community

sanjeeva_279 · ‎2020-03-12

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 · ‎2020-04-08

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.