Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can some one advise me.
Paul
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
my qvw
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
Hi Sunny
Appreciate your help a lot. it work fine.
Paul