Hide the Expression for particular dimension value

[nareshthavidishetty]

Hi,

we need to hide the Expression for particular dimension value

We having hard coded dimension 'KPI' field

LOAD * INLINE [

    KPI, SortOrder

    FEBRUARY 2016, 1

    FEBRUARY 2015, 2

    DELTA by MARKET, 3

    DELTA by SSS, 4

   ];

For FEBRUARY 2016- 7 expressions

For FEBRUARY 2015- 7 expressions

For DELTA by MARKET- 3 expression

For DELTA by SSS - 3 expression

currently for DELTA by SSS and DELTA by MARKET we getting 3 expression and 4 empty expressions

How to hide the empty expressions.

Thanks..

[nareshthavidishetty]

Hi,

Is there any approach to get this requirement.

Thanks..

[sunny_talwar]

How do you define empty here?

[nareshthavidishetty]

There is no expression for that.

Want to hide that.

Thanks..

[sunny_talwar]

Can you try a hide show condition like this:

Count(Aggr(YourExpression, YourDimensions)) > 0

or

Len(Trim(Avg(Aggr(YourExpression, YourDimensions)))) >= 0

Replace YourExpression with the expression for which we are going to use this hide/show condition for and YourDimensions need to be replaced with all the dimensions you are using in this chart.

[nareshthavidishetty]

It's working.

How to compare two fields in front end chart via set analysis  or if condition.

Thanks..

[sunny_talwar]

This seems like a totally unrelated requirement, do you mind closing this thread and opening another one for the new requirement?

Best,

Sunny

[nareshthavidishetty]

Hi,

Can you explain how this is working.

Thanks..

[sunny_talwar]

Not sure which one of the two worked? 1st, 2nd or both? I will explain accordingly

[nareshthavidishetty]

Hi,

Count(Aggr(YourExpression, YourDimensions)) > 0

Thanks..