Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

varunreddy
Contributor III

Hide Dimension on select

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

1 Solution

Accepted Solutions

Re: Hide Dimension on select

Try this

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

12 Replies

Re: Hide Dimension on select

Try this

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

varunreddy
Contributor III

Re: Hide Dimension on select

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

Cheers!

Re: Hide Dimension on select

Hi Varun,

Thought of sharing another method.

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

varunreddy
Contributor III

Re: Hide Dimension on select

Thanks Nagaraj

varunreddy
Contributor III

Re: Hide Dimension on select

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.

Re: Hide Dimension on select

My bad. Sorry Varun.

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

varunreddy
Contributor III

Re: Hide Dimension on select

This is working

Cheers!

Re: Hide Dimension on select

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

GetSelectedCount(Dimension)=0

Re: Hide Dimension on select

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.