Conditionally show columns in Table by selecting values from list box

[Shivam22]

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

A

B

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 · Accepted solution]

Hi your expression has extra ']'

Otherwise it works

[Shivam22]

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]

Did you upload my app or recreated it?

Cloud