3 Replies Latest reply: Oct 27, 2016 11:24 AM by Yeo Poh sai

# My chart have 7 Bar , How to make it only display first 6 bar ?

Hi All

I have below expression working fine :-

=If(Month_n >= 1 and Month_n <= 1, Dual('1 mth ago', 1),

If(Month_n >= 2 and Month_n <= 2, Dual('2 mth ago', 2),

If(Month_n >= 3 and Month_n <= 3, Dual('3 mth ago', 3),

If(Month_n >= 4 and Month_n <= 5, Dual('4 mth ago', 4),

If(Month_n >= 5 and Month_n <= 5, Dual('5 mth ago', 5),

If(Month_n >= 6 and Month_n <= 6, Dual('6 mth ago', 6), Dual('>7 mth ago', 7)))))))

It will display total 1 mth ago till >7 mth ago Bar.

and i like to remove the last Bar >7 mth ago , so i modify the above expression to below :-

=If(Month_n >= 1 and Month_n <= 1, Dual('1 mth ago', 1),

If(Month_n >= 2 and Month_n <= 2, Dual('2 mth ago', 2),

If(Month_n >= 3 and Month_n <= 3, Dual('3 mth ago', 3),

If(Month_n >= 4 and Month_n <= 5, Dual('4 mth ago', 4),

If(Month_n >= 5 and Month_n <= 5, Dual('5 mth ago', 5),

If(Month_n >= 6 and Month_n <= 6, Dual('6 mth ago', 6), ))))))

But it does not work. it only remove the label not the bar.

Paul

my qvw

• ###### Re: My chart have 7 Bar , How to make it only display first 6 bar ?

May be use this as your calculated dimension

=If(Month_n >= 1 and Month_n <= 1, Dual('1 mth ago', 1),

If(Month_n >= 2 and Month_n <= 2, Dual('2 mth ago', 2),

If(Month_n >= 3 and Month_n <= 3, Dual('3 mth ago', 3),

If(Month_n >= 4 and Month_n <= 5, Dual('4 mth ago', 4),

If(Month_n >= 5 and Month_n <= 5, Dual('5 mth ago', 5),

If(Month_n >= 6 and Month_n <= 6, Dual('6 mth ago', 6)))))))

And select 'Suppress When Value Is Null' on the dimension tab for the above calculated dimension

• ###### Re: My chart have 7 Bar , How to make it only display first 6 bar ?

Hi Sunny

Appreciate your help a lot. it work fine.

Paul