For every Quarter the corresponding month need to be displayed

[#1]

Hi,

I am new to Qlikview.I have a requirement where we have three Dimension Year,Quarter, Month and One Measure for a bar Chart. In X-axes we need Two Dimension Month and Quarter and Year should Diplayed as Legends.

For every Quarter say for Q1, only 3 months should be displayed ie Jan/Feb/ and Mar, were as we are receiving all the 12 months, Out of which 3 months are with data and for the remaining 9 months it displays empty data.

for ex.

Q1 : Jan, Feb, Mar are with measure to be displayed and the remaining 9 months Apr, May....Dec need to be hidden.

Q2 : Apr, May, Jun are with measure to be displayed and the remaining 9 months need to hidden.

Q3 : Jul, Aug, Sep are with measure to be displayed and the remaining 9 months need to hidden.

Q4 : Oct, Nov, Dec are with measure to be displayed and the remaining 9 months need to hidden.

Kindly please do the needful with your valuable suggestions to resolve the above requirement as this is the immediate requireent to be resolved.

Thanks & Regards,

Vivek

[#2]

Hi,

I would suggest you to build a drill down group containing Year, Quarter and Month. Do this with --> chart properties --> dimensions tab --> edit groups (lower left corner) --> add new group and fill it with the members in a vulnerable order. Then use this group as the only dimension in your chart and play around with it.

Regards, Roland

[maneshkhottcpl]

can u send the sample application?

[maneshkhottcpl]

Use this script in backend, will create a new Filed as Quarter acording to Date month.

if(match(num(month(Start_Date)),'1','2','3'),'Q1',

if

(match(num(month(Start_Date)),'4','5','6'),'Q2',

if

(match(num(month(Start_Date)),'7','8','9'),'Q3',

if

(match(num(month(Start_Date)),'10','11','12'),'Q4')))) as Quarter

please refer the attached file

[#5]

Thanks for your quick responce.

As per you suggestion, the chart functions as drill from one level to another. Where as my requirement is to display both dimensions Month and Qtr in X-axis at all times as a Static chart.

The below displayed is what we are getting, we would like to display only Jan/Feb/Mar for Q1 similarly for the remaining Quaters.

Thanks & Regards,

Vivek.

[maneshkhottcpl]

if(match(num(month(Start_Date)),'1','2','3'),'Q1',
if(match(num(month(Start_Date)),'4','5','6'),'Q2',
if(match(num(month(Start_Date)),'7','8','9'),'Q3',
if(match(num(month(Start_Date)),'10','11','12'),'Q4')))) & right(year(Start_Date),2) as Quarter

[#7]

Hi Maneshkhot,

Thanks for your inputs. Tested with the code you had provided, but unfortunately its diplaying the same result as before.

Thanks & Regards,

Vivek.