Chart(How to get 2014 Q1)

[deepakqlikview_123]

Hi All,

How to get 2014 Q1 in below chart

Please find image below\

[deepakqlikview_123]

Hi Prem,

Data for last year should be accumulated.

Mean if data is till Q2 for 2014 then it can show 2014 Q1+Q2

if data is till Q3 then it can show data for 2014 Q1+Q2+Q3

Thanks

[deepakqlikview_123]

Hello All,

Is there any update on this.

Thanks

[preminqlik]

hope this helps you

[stevedark]

Hi Deepak,

You could try taking a look at this article:

http://www.quickintelligence.co.uk/qlikview-accumulate-values/

It describes adding an average bar to a bar chart, and the technique could be used for adding the quarter for the current year.

Simply create a table that joins quarters into years for old years, and to itself for current year, ie.

Qtr,ChartDim

2014 QI,2014

2014 Q2,2014

2014 Q3,2014

2014 Q4,2014

2015 Q1,2015 QI

2015 Q2,2015 Q2

The colour should be relatively simple to do also.

Hope that helps,

Steve

[deepakqlikview_123]

Hi Prem,

Thanks it is working.

Can you please suggest how to get different color for last bar as shown in attachment.

Thanks