show column if condition in Qliksense table

abhijith28 — Tue, 11 Oct 2022 06:32:07 GMT

HI,

I am working on one scenario in Qliksense table, show column if condition for adhoc reporting.

In my dimension there are two values, only when the user selects the dimension the column should appear in the table.

1. Product type

2. Product type details

below is the condition in show column if

if(SubStringCount(GetFieldSelections(Dim_Name, ',',50),'Product type')>0,1,0)

if(SubStringCount(GetFieldSelections(Dim_Name, ',',50),'Product type details')>0,1,0)

Issue:

Even when the users selects "Product type details", "Product type" gets activated in the table.

So, I need to modify the condition. Please help

Thanks,

Abhijith

topic show column if condition in Qliksense table in App Development