topic Re: Conditionally show columns in Table by selecting values from list box in App Development

Conditionally show columns in Table by selecting values from list box

Shivam22 — Sun, 19 Oct 2025 01:38:22 GMT

Hi All,

I have a table and i want to show columns only when i select values in list box.

Table

CloumnA , CloumnB, ColumnC, Measue1,Measure2

AAA, BBB, CCC, 34, 36

I created an inline table to select dimensions from

load * lnline [

_Dim

C];

So, when user select A , ColumnA should appear, and when select B CloumnB should appear and when select C ColumnC should appear,

I am using formula at shoudcoulmnif for ColumnA = substringcount(concat(GetFieldSelections( _Dim],100),','),'A')

Same for ColumnB -substringcount(concat(GetFieldSelections(_Dim],100),','),'B')

ColumnC- substringcount(concat(GetFieldSelections(_Dim],100),','),'C')

Now, it only works when i select A and B from _Dim List box (filter)and as soon as i select C - all columns disappeared.

i think it is to do with Getfiledselections - when i select all values it displays "ALL",and that's causing problems.

Can anyone please help me?

Thanks in Advance

robert_mika — Sun, 19 Oct 2025 05:24:41 GMT

Hi your expression has extra ']'

Otherwise it works

Shivam22 — Sun, 19 Oct 2025 22:06:00 GMT

Thanks @robert_mika , i don't know if it's a bug in Qlik cloud but the formula is not working.

I used below formula to make it work.

if(GetFieldSelections( _Dim)='ALL',1,
if(substringcount(concat(GetFieldSelections(_Dim,100),','),'A')>=1,1,0))

Thank You!

robert_mika — Mon, 20 Oct 2025 04:20:25 GMT

Did you upload my app or recreated it?

Cloud