# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
New Contributor III

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

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/...

any help on this will be appreciated.

Thanks & Regards,

Arun

2 Solutions

Accepted Solutions
Valued Contributor

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

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

`=SUM({\$<Date={"<\$(=DATE(QUARTERSTART(TODAY())))"}>} Revenue)`
Valued Contributor

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

You can sort the dimension based on date

9 Replies
Valued Contributor

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

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

New Contributor III

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

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

New Contributor III

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

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

Valued Contributor

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

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

`=SUM({\$<Date={"<=\$(=DATE(QUARTERSTART(TODAY())))"}>} Revenue)`
New Contributor III

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

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

Valued Contributor

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

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

`=SUM({\$<Date={"<\$(=DATE(QUARTERSTART(TODAY())))"}>} Revenue)`
New Contributor III

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

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

Valued Contributor

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

You can sort the dimension based on date

New Contributor III

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

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

Have a Nice day!!!