topic Hide Dimension on select in QlikView

Hide Dimension on select

varunreddy — Sun, 25 Feb 2018 17:12:24 GMT

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

Re: Hide Dimension on select

sunny_talwar — Sun, 25 Feb 2018 17:22:26 GMT

Try this

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

Re: Hide Dimension on select

varunreddy — Sun, 25 Feb 2018 17:40:23 GMT

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

Cheers!

Re: Hide Dimension on select

tamilarasu — Sun, 25 Feb 2018 17:45:20 GMT

Hi Varun,

Thought of sharing another method.

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

Re: Hide Dimension on select

varunreddy — Sun, 25 Feb 2018 17:50:22 GMT

Thanks Nagaraj

Re: Hide Dimension on select

varunreddy — Sun, 25 Feb 2018 17:55:18 GMT

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

tamilarasu — Sun, 25 Feb 2018 18:02:44 GMT

My bad. Sorry Varun.

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

Re: Hide Dimension on select

varunreddy — Sun, 25 Feb 2018 18:06:37 GMT

This is working

Cheers!

Re: Hide Dimension on select

sunny_talwar — Sun, 25 Feb 2018 18:10:38 GMT

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

tamilarasu — Sun, 25 Feb 2018 18:18:56 GMT

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.

Re: Hide Dimension on select

varunreddy — Sun, 25 Feb 2018 18:22:52 GMT

I have 47 fields and 33 million records. I have using one dimension and remaining fields in Expression. Just curious to know if which will have better performance.

Re: Hide Dimension on select

tamilarasu — Sun, 25 Feb 2018 18:32:47 GMT

I think both will have the same performance since we are not doing any calculations. We are just checking whether the field names are matching with the selections or not. Kindly let us know if you find any performance difference between those two solutions.

Re: Hide Dimension on select

varunreddy — Sun, 25 Feb 2018 18:39:44 GMT

Sure will do.

Thanks again both of you

Cheers!