Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
deepaktibhe
Valued Contributor

Chart(How to get 2014 Q1)

Hi All,

How to get 2014 Q1 in below chart

Please find image belowUntitled.jpg\

14 Replies

Re: Chart(How to get 2014 Q1)

Could you post your data set?

And what Dimension/Expression you have at the moment

deepaktibhe
Valued Contributor

Re: Chart(How to get 2014 Q1)

I have dim in  year not in qtr.

Thanks

ravic906
Contributor III

Re: Chart(How to get 2014 Q1)

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

deepaktibhe
Valued Contributor

Re: Chart(How to get 2014 Q1)

Can you please share example.

Thanks

Re: Chart(How to get 2014 Q1)

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

ravic906
Contributor III

Re: Chart(How to get 2014 Q1)

PFA

Partner
Partner

Re: Chart(How to get 2014 Q1)

use this dim

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

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

Year&'-'&Quarter),Year)

deepaktibhe
Valued Contributor

Re: Chart(How to get 2014 Q1)

Hi Prem,,

Thanks for response.

We want  to show this dynamically.

Is there any other way to show this.

Thanks

preminqlik
Valued Contributor II

Re: Chart(How to get 2014 Q1)

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