topic Re: Hide Column/Show Column in QlikSense based on filter selection in App Development

Hide Column/Show Column in QlikSense based on filter selection

abc_18 — Sat, 16 Nov 2024 06:09:33 GMT

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

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

Re: Hide Column/Show Column in QlikSense based on filter selection

vikasmahajan — Thu, 04 Apr 2019 11:33:06 GMT

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 ..
];

Re: Hide Column/Show Column in QlikSense based on filter selection

bhargav_bhat — Thu, 04 Apr 2019 11:33:43 GMT

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

Re: Hide Column/Show Column in QlikSense based on filter selection

miskinmaz — Thu, 04 Apr 2019 11:36:10 GMT

Hi,

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