Hide Column/Show Column in QlikSense based on filter selection

[abc_18]

Hi,

In our report we are using  the business filter box to filter out the table values based on selection.

We have a filter box called business with three different values.

Business

Manufacture

IT

clinical

Now requirement is to show some of the columns in table based on the user selection.

Like a particular column in table should be visible, only if user has selected the business value  either as 'IT' or 'Clinical'.

That particular column should be visible for both the selections.

Thanks

[vikasmahajan]

You can try to use associative logic using loading table you can use dimension along with for example
Table1:
Load * inline [
Dimension , Field 1, field2 ...
clinical , Field value1,FieldValue2 ..
];

Table 2
Load * inline [
Dimension , Field 1, field2 ...
IT , Field value1,FieldValue2 ..
];

[bhargav_bhat · Accepted solution]

Hi ShikhaKumari,

Please go through this video they have explained the condition to use in the show if column condition

https://www.youtube.com/watch?v=z75R7bThGZY

Regards,

Bhargav

[miskinmaz]

Hi,

We can use the "Show Column If" property of a table using the if condition of getselected count.