topic Chart(How to get 2014 Q1) in QlikView

Chart(How to get 2014 Q1)

deepakqlikview_123 — Wed, 11 Feb 2015 04:28:41 GMT

Hi All,

How to get 2014 Q1 in below chart

Please find image below\

Re: Chart(How to get 2014 Q1)

robert_mika — Wed, 11 Feb 2015 04:42:56 GMT

Could you post your data set?

And what Dimension/Expression you have at the moment

Re: Chart(How to get 2014 Q1)

deepakqlikview_123 — Wed, 11 Feb 2015 04:45:40 GMT

I have dim in year not in qtr.

Thanks

Re: Chart(How to get 2014 Q1)

Anonymous — Wed, 11 Feb 2015 05:11:19 GMT

Hola,

use some magic. Draw another bar chart and take away axes and values from it. Just get the bar beside the other bar chart. sometimes you need to do such stuff.

HTH

Re: Chart(How to get 2014 Q1)

deepakqlikview_123 — Wed, 11 Feb 2015 05:24:19 GMT

Can you please share example.

Thanks

Re: Chart(How to get 2014 Q1)

robert_mika — Wed, 11 Feb 2015 05:31:11 GMT

Is your data set in Day by Day Format?

Sample,please...

What Ravichandra suggest is to create another chart with only Q4 bar and manually add/adjust into your current chart

Re: Chart(How to get 2014 Q1)

Anonymous — Wed, 11 Feb 2015 05:35:24 GMT

PFA

Re: Chart(How to get 2014 Q1)

preminqlik2 — Mon, 23 Mar 2015 09:30:28 GMT

use this dim

=if(Year='$(=max(Year))' ,

if(Year='$(=max(Year))' and Quarter='$(=maxstring({<Year={$(=max(Year))}>}Quarter))',

Year&'-'&Quarter),Year)

Re: Chart(How to get 2014 Q1)

deepakqlikview_123 — Tue, 24 Mar 2015 02:44:08 GMT

Hi Prem,,

Thanks for response.

We want to show this dynamically.

Is there any other way to show this.

Thanks

Re: Chart(How to get 2014 Q1)

preminqlik — Tue, 24 Mar 2015 03:50:38 GMT

i guess it is dynamic only....can you explain how you want in dynamic?

Re: Chart(How to get 2014 Q1)

deepakqlikview_123 — Tue, 24 Mar 2015 04:50:58 GMT

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

Re: Chart(How to get 2014 Q1)

deepakqlikview_123 — Tue, 24 Mar 2015 07:20:04 GMT

Hello All,

Is there any update on this.

Thanks

Re: Chart(How to get 2014 Q1)

preminqlik — Tue, 24 Mar 2015 08:11:21 GMT

hope this helps you

Re: Chart(How to get 2014 Q1)

stevedark — Tue, 24 Mar 2015 08:13:49 GMT

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

Re: Chart(How to get 2014 Q1)

deepakqlikview_123 — Mon, 30 Mar 2015 11:33:56 GMT

Hi Prem,

Thanks it is working.

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

Thanks