topic Re: show or hide column by selection in QlikView

show or hide column by selection

omyahamburg — Thu, 28 Feb 2013 10:56:53 GMT

Hello

I have a table as below shown. By choosing values from the Selection listbox I want to hide/show the columns in my table.

I tried with conditional show

GetFieldSelections(Selection)='Quantity' which works for the first column, but if I add to the others

the corresponding expression it does not work any longer.

I do attach the sample.

best regards

Joerg

Can someone let me know what I am doing wrong ?

Re: show or hide column by selection

Gysbert_Wassenaar — Thu, 28 Feb 2013 11:14:31 GMT

If you select more than one value the getfieldselections returns more than just the value you want to check for. Use substringcount instead:substringcount(concat(Selection),'Quantity')

Re: show or hide column by selection

omyahamburg — Thu, 28 Feb 2013 11:25:52 GMT

Thanks Gysbert

You saved my day.

Joerg

Re: show or hide column by selection

Anonymous — Thu, 17 Dec 2015 13:55:47 GMT

Hi Jorg

I want to do the same but I have now knowledge syntaxis used here. Could you explain me the step by step of how to do it?

Re: show or hide column by selection

omyahamburg — Thu, 17 Dec 2015 15:44:09 GMT

Hi Lucas

Unfortunately I have to leave my Office right now, but try to give you an example tomorrow.

Good Morning Lucas

Maybe the attached document helps to understand how it works.

regards

Joerg

Re: show or hide column by selection

brooksc57 — Wed, 17 Aug 2016 16:03:23 GMT

I am using a LED checkbox for selection of fields and only want the ones a user selects to appear...so basically if ALL then none or if none selected...no columns appear....note: my reason is that there are alot/too many columns when blank.

This is the formula for that scenario

--------------------------------------------------------------------------------------------------------------------------

count(GetFieldSelections(Selection)>0) and substringcount(concat(Selection),'Quantity')

Thanks,

Brooks

Re: show or hide column by selection

apthansh — Wed, 24 May 2017 12:04:22 GMT

Hi Gysbert -

Can we do this in Qliksense ?

I tried and it doesn't work.See attached QVF.

Also attached are the extension I am using.

Please suggest if you have better solution.

Thanks much.

rwunderlich‌jontydkpi‌sunny‌swuehl‌

Re: show or hide column by selection

Thu, 13 Jul 2017 19:33:05 GMT

Really simple, thank you. Nice example too.

Re: show or hide column by selection

Shubham_Deshmukh — Mon, 02 Apr 2018 05:35:20 GMT

But after unselecting the filter, column is not getting hide.