Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
arunqlik2view
Creator
Creator

How to show only the completed financial Quarters?

Hello All, 

 

I'm trying to show the Bar chart only for completed Quarters. Please check the attachment for the data file to be used. 

 

 

Thanks in Advance,

Arun 

6 Replies
Anil_Babu_Samineni

What is the logic behind to see the Quarters? Which is done and which is not?
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
shiveshsingh
Master
Master

After analyzing your data, it is having entry till 26th Nov. So how your quarter is starting? from Jan or from April?

Do one thing, let me know the expected output from your excel file.

arunqlik2view
Creator
Creator
Author

Untitled.jpgHi , 

I got the output I needed, the only difference I don't want to see the Q3 as it is not completed. 

Where ,

Q4 / FY-18 is Jan to Mar 2018 , 

Q1 / FY19 is Apr to Jun 2018, 

Q2 / FY19 is Jul to Sep 2018, 

Q3 / FY19 is Oct to Dec 2018.  This Quarter is incomplete as we are still in Nov 2018.

arunqlik2view
Creator
Creator
Author

The data I shared has just one dimension = Date1, 1 measure = Revenue.

shiveshsingh
Master
Master

you can prepare a condition, find out 4 quarter end dates and on basis of those dates show the quarter data.

suppose today is 28th Nov and quarter end date is 31 Dec, then don't show Q3 as today() < 31 dec

avkeep01
Partner
Partner

Hi @arunqlik2view

 

You can use the QUARTERSTART or QUARTEREND function. In this the dates are only shown till the start of the current quarter. Oct-2018. 

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