Hide Dimension on select

[varunreddy]

Hi All,

I have a straight table and I am trying to show all the expressions by default and hide the expressions when selected.

I have created the inline load using the field names. I have one dimension and 2 expressions. I am trying to hide the expressions when selected. I tried below expression, but is working when on value is selected and not when multiple.

Concat(Dimesnion,',') = 'Value'.

Can someone please help?

Thanks,

Varun

[sunny_talwar · Accepted solution]

Try this

NOT SubStringCount('|' & GetFieldSelections(Dimension, '|') & '|', '|PRSL|')

[varunreddy]

Thanks Sunny. I have tried Not SubstringCount but missed pipe logic.

Cheers!

[tamilarasu]

Hi Varun,

Thought of sharing another method.

GetSelectedCount(Dimension)=0 Or Not Match(GetFieldSelections(Dimension,', '),'PRSL')

[varunreddy]

Thanks Nagaraj

[varunreddy]

Nagaraj, this solution is working fine when one value is selected but when both PRSL and Rel is selected, we are seeing the values in the chart instead of hiding. Just wanted you to inform.

[tamilarasu]

My bad. Sorry Varun.

GetSelectedCount(Dimension)=0 Or Not Index(GetFieldSelections(Dimension),'PRSL')

[varunreddy]

This is working

Cheers!

[sunny_talwar]

Do we really need the first part here? Just trying to see why this would be needed?

GetSelectedCount(Dimension)=0

[tamilarasu]

Ha. It's not required. I was trying to correct my mistake and completely forgot about this part (and again did a silly mistake). Thanks for pointing it out. It's similar to your suggestion and nothing has changed except index function.

Not Index(GetFieldSelections(Dimension),'PRSL')

Edit: Varun, Just to be safe please use any symbols before and after the dimension name like Sunny used.