Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Any sample app or data?
Suppress Null Values did not work?
Hi Avinash,
Enable "Suppress When Value is Null" option in dimension tab.
No It is not working.
We have given suppress value is null option as check in dimension but no changes are sone.
Any suuggestions
No it is not working
Can you post sample application?
HI,
Try like this
Dimension - if(DATE>='12/31/1980',YEAR)
Expression1 - If(Count(DISTINCT Quarter) = 4, avg({<NAME={'A'}>VALUE))/100, Null())
Expression2 - If(Count(DISTINCT Quarter) = 4, avg({<NAME={'B'}>VALUE))/100, Null())
Expression3 - If(Count(DISTINCT Quarter) = 4, avg({<NAME={'C'}>VALUE))/100, Null())
If not working can you attach some sample file.
Regards,
Jagan.
try like this in calculated dimension.. and enable the 'Suppress When Value is Null'
=if(aggr(sum(if(isnull(Quarter),1)),Year)=0,Year)
Edit:
=if(Date> '12/31/1980' and aggr(sum(if(isnull(Quarter),1)),Year)=0,Year)
dude,
its already done in country specific charts.
take the reference.
In which chart depak in country specific.