Hide YEAR when any quarter is null

[#1]

Hi All,

I have one dimension and three expressions

Dimesnion - if(DATE>='12/31/1980',YEAR)

Expression1 - avg({<NAME={'A'}>VALUE))/100

Expression2 - avg({<NAME={'B'}>VALUE))/100

Expression3 - avg({<NAME={'C'}>VALUE))/100

Now i want to hide YEAR in my chart for any quarter Q1,Q2,Q3,Q4 is null for those NAMES in the expression, then whole YEAR Should not be shown in my Chart.

Please let me know if there are  any concerns

Thanks

Avinash

jagan‌

[PradeepReddy]

wtz the output you are expecting for? some thing like this...

[#3]

Sorry for wrong requirement to jagan‌ and @sunny T and Pradeep.

Many thanks for your help.

Actually the values are not 'null' in my data base it is '0.0' values so that's why it is not working.

Now I have resolved the issue and it is hiding the YEAR's and Chart is displaying correctly.

Many thanks once again

Thanks

Avinash

[jagan]

HI,

If you got the answer close this thread by giving Correct Answer to the post which helps you.

Regards,

Jagan.

[#5 · Accepted solution]

Hi All,

if(isnull(((avg({<NAME={'A'},QUARTER={'Q4'}>}VALUE))/100))

or ((avg({<NAME={'A'},QUARTER={'Q4'}>}VALUE))/100=0

or

isnull(((avg({<NAME={'A'},QUARTER={'Q3'}>}VALUE))/100

or ((avg({<NAME={'A'},QUARTER={'Q3'}>}VALUE))/100)=0

or

isnull(((avg({<NAME={'A'},QUARTER={'Q2'}>}VALUE))/100

or ((avg({<NAME={'A'},QUARTER={'Q2'}>}VALUE))/100=0

or

isnull(((avg({<NAME={'A'},QUARTER={'Q1'}>}VALUE))/100

or ((avg({<NAME={'A'},QUARTER={'Q1'}>}VALUE))/100=0

, null(),

((avg({<NAME={'A'}>}VALUE))/100)