Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

How can I show only the months for current quarter

Hello

I need some help to show data in a graph which only shows the months for the current quarter

I.e.   QU1 = Apr - June

        QU2 - Jul - Sept

        QU3 - Oct - Dec

        QU4 - Jan - Mar

I have a field (See below) which show all the months of the year but I want my chart to just show the months for the current quarter

CWT_Monthly_desc.desc_month_Year

Can anyone show me how I get this to show in a bar chart?

 

Kind Regards

Helen

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try this calculated dimension: =if(InQuarter( CWT_Monthly_desc.desc_month_Year, Today(),0), date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY'))

This won't show anything in the qvw you posted since the current quarter is now 3 and your document doesn't contain data for this quarter. If you update your document with data for this quarter the chart should show the data of the current quarter. You can try it out anyway by changing the offset from 0 to -1 so that it shows the data of the previous quarter:  =if(InQuarter( CWT_Monthly_desc.desc_month_Year, Today(),-1), date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY')). See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
shree909
Partner - Specialist II
Partner - Specialist II

Hi,

could u please post a sample file...

helen_pip
Creator III
Creator III
Author

Hello

Thank you for any help in advance

Please find attached a QVW which shows a graph which is showing data from Apr 2012 - June 2013

However what I want to do is map the quarters map to the field called:

CWT_Monthly_desc.Month

so that I can get a link between the quarters map and the dataset

What I then want is for the graph to only ever show the current quarter - At the moment the current Quarter is showing for each month

(I have attached file to my original question)

Are you able to provide any assistance?

Thanks

Helen

helen_pip
Creator III
Creator III
Author

Hello 

Thank you for this, I think this is a useful thing to know

However when I use this I get Quarter 1,2,3 and 4 showing.  What I would like to show is the months for the Current Quarter

I.e. at the moment the max quarter is 2 and I would ideally like to show the month July - Sept along the X axis of my graph

Are you able to help?

Thanks

Helen

jerem1234
Specialist II
Specialist II

here maybe try this in your dimension of your chart:

=if(mod(ceil(Month(QuarterStart(CWT_Monthly_desc.desc_month_Year))/3)-2,4)+1 = Current_Quarter, date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY'))

Then check the box supress when value is null. This will only show the months for the current quarter 2.

You could do as mohit did and do it in loadscript:

mod(ceil(Month(QuarterStart(DATEFIELD))/3)-2,4)+1 as QuarterNum

Then maybe in dimension:

if(QuarterNum = Current_Quarter, date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY'))

and check the box supress when value is null.

Hope this helps.

Note:

mod(ceil(Month(QuarterStart(CWT_Monthly_desc.desc_month_Year))/3)-2,4)+1 does the same thing as mohit's formula above except without the 'QU'.

Gysbert_Wassenaar

Try this calculated dimension: =if(InQuarter( CWT_Monthly_desc.desc_month_Year, Today(),0), date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY'))

This won't show anything in the qvw you posted since the current quarter is now 3 and your document doesn't contain data for this quarter. If you update your document with data for this quarter the chart should show the data of the current quarter. You can try it out anyway by changing the offset from 0 to -1 so that it shows the data of the previous quarter:  =if(InQuarter( CWT_Monthly_desc.desc_month_Year, Today(),-1), date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY')). See attached qvw.


talk is cheap, supply exceeds demand
helen_pip
Creator III
Creator III
Author

Thanks so much for your Help, this has really helped

Sorry to be a pain, but If I were to load in July data and the calculated dimension has Today()-1).  How could I get the calculated dimension to change to Today(),0)?

Thanks for any help in advance

Thanks

Helen