How to show current FY/QTR and next 3 QTR's in bar chart

[mrainford]

I have a date field (PRIMARY_DC_DATE) , format, DD/MMM/YYYY, in which I need to show the current Fiscal and Quarter along with the following quarters by sum of PIPE_REVENUE in a chart.

Example data with fiscal and qtr already transformed using PRIMARY_DC_DATE below. 

Fiscal Year	QTR	Overall Status	Sum Pipe Revenue
FY17	Q1	HIGH	11.96
FY17	Q1	MEDIUM	76.16
FY17	Q1	LOW	122.34
FY17	Q2	HIGH	100.05
FY17	Q2	MEDIUM	112.47
FY17	Q2	LOW	240.36
FY17	Q3	HIGH	30.72
FY17	Q3	MEDIUM	307.13
FY17	Q3	LOW	136.78
FY17	Q4	HIGH	29.58
FY17	Q4	MEDIUM	136.31
FY17	Q4	LOW	236.31
FY18	Q1	HIGH	42.58
FY18	Q1	MEDIUM	159.31
FY18	Q1	LOW	286.31

Since current fiscal is FY17 Q2 (we are using July-Jun for fiscal months). I want to show FY17 Q2,Q3,Q4 & FY18 Q1. The attachment show the end result. Your help is much appreciated. thanks

[mrainford]

Can you please send me the app to determine how you were able to achieve this? thanks

[sunny_talwar]

It is attached here:

Re: How to show current FY/QTR and next 3 QTR's in bar chart

[mrainford]

Will need to validate further, however, it appears to work like a charm. Thanks very much for your help.

[sunny_talwar]

Will wait for your validation . Also, it would be better if you mark a response which is truly a correct response because this might come handy for others in the future.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny