show and hide column (expression) based on listbox selection

robmarr789 — Sat, 16 Nov 2024 04:03:12 GMT

On the attached you will see that when a list box selection is selected it will add it to the table.

However when all selections are removed all columns still appear.

How can I alter the condition code so that each column can be added and removed independently of one an other and if one is not selected it will not appear regardless of no other selections being made.

Re: show and hide column (expression) based on listbox selection

dplr-rn — Mon, 25 Mar 2019 20:13:15 GMT

Hope i understood your problem correctly.
If what you want is, when nothing is selected no columns should appear.
change to something like below
if(GetSelectedCount(Selection)>0,
substringcount(concat(Selection),'Quantity')
,0)

topic show and hide column (expression) based on listbox selection in QlikView

show and hide column (expression) based on listbox selection

Re: show and hide column (expression) based on listbox selection