topic Re: How to show only the completed financial Quarters in Dimension for Qlikview? in QlikView

How to show only the completed financial Quarters in Dimension for Qlikview?

arunqlik2view — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Hope you all had a great year so far and Wish you all Advanced Happy Prosperous New Year.

Coming to my Question .

I just want to see only the completed Financial Quarters in the bar chart, even one day is left to complete the 3 month Financial Quarter, I don't want qlikview to show in the histogram Chart. I have searched a lot and but no luck. This is my second post with the same Question in the Qlikview blog . Here is the link for my first post on this question - https://community.qlik.com/t5/New-to-QlikView/How-to-show-only-the-completed-financial-Quarters/m-p/1513314#M365721

any help on this will be appreciated.

Thanks & Regards,

Arun

Re: How to show only the completed financial Quarters in Dimension for Qlikview?

avkeep01 — Fri, 07 Dec 2018 08:18:44 GMT

Hi @arunqlik2view,

I replied to the post you mentioned. Hopefully it works for you.

Re: How to show only the completed financial Quarters in Dimension for Qlikview?

arunqlik2view — Fri, 07 Dec 2018 08:59:12 GMT

Hi ,

Thanks for the quick reply. I tried your syntax =SUM({$<Date{"<=$(QUARTERSTART(TODAY()))"}>} Revenue) , in the expression . I kept the date value in the dimension, Also tried FY Quarters in the dimension , either ways it did not work work for me . I got " No data to display" .

Please let me know what am I doing wrong here .

Thanks & Regards,

Arun

Re: How to show only the completed financial Quarters in Dimension for Qlikview?

arunqlik2view — Fri, 07 Dec 2018 08:59:35 GMT

Hi ,

Please let me know what am I doing wrong here .

Thanks & Regards,

Arun

Re: How to show only the completed financial Quarters in Dimension for Qlikview?

avkeep01 — Fri, 07 Dec 2018 09:08:56 GMT

Sorry my expression wasn't correct, marked my changes in red. Could you try this one:

=SUM({$<Date={"<=$(=DATE(QUARTERSTART(TODAY())))"}>} Revenue)

Re: How to show only the completed financial Quarters in Dimension for Qlikview?

arunqlik2view — Fri, 07 Dec 2018 10:45:25 GMT

Hi , Now it shows the data in the chart , but still it is not filtering the incomplete Quarter.

Re: How to show only the completed financial Quarters in Dimension for Qlikview?

avkeep01 — Fri, 07 Dec 2018 10:57:38 GMT

In the expression I use <= instead of <. Maybe the first day of the quarter is still include.

=SUM({$<Date={"<$(=DATE(QUARTERSTART(TODAY())))"}>} Revenue)

Re: How to show only the completed financial Quarters in Dimension for Qlikview?

arunqlik2view — Fri, 07 Dec 2018 11:11:56 GMT

Hi , This syntax worked fine, I want the charts in the order of Q4- FY 2018 , Q1 FY 2019 . Q2 Fy2019 .

Re: How to show only the completed financial Quarters in Dimension for Qlikview?

avkeep01 — Fri, 07 Dec 2018 11:16:02 GMT

You can sort the dimension based on date

Re: How to show only the completed financial Quarters in Dimension for Qlikview?

arunqlik2view — Mon, 10 Dec 2018 14:21:41 GMT

Thank for the providing the solution. That fixes my issue.

Have a Nice day!!!