Hide Column/Show Column in QlikSense based on filter selection

[malyadri1004]

Hi,

In my report  we are having 20 columns , Now requirement is to show some of the columns ( based on required columns which I want show ) in table based on the user selection.

For Eg : 

Due amount	Paid 7 D	Paid 15 D	Paid 30D	Paid 45 D
100	10	25	49	79
200	45	67	78	90
300	50	100	150	200
400	95	150	230	315
500	300	320	370	450

I want to hide/filtered columns in above table in qlik sense

If I want to select DueAmount,[Paid 7 D],[Paid 15 D] then I need data only these columns and hide remaining columns

Thank you,

Malyadri P

[JordyWegman]

Hi Malyadri,

You can make conditions, but what are the conditions? For example, show only when 1 selection in a filter pane is left? Then you can do GetPossibleXXXX for example.

Jordy
Climber

[micheledenardi]

You can create a data island table with the table columns names and put into a filter pane, so:

TableSetting:
load * Inline [
ColumnName
Column1
Column2
Column3
Column4];

Then on each column you have to set something like the following show/hide formula:

If(isnull(GetFieldSelections(ColumnName)),1,
if(substringCount(concat('|'&ColumnName&'|',','),'|Column1|')>0,1,0))

[anshud28]

Hello,

There is an option in Qliksense "Show Column If". You can assign "0" value for the columns which you do not want to show the column in your report and you can assign value "1" if you want to show the column in your table. Attached screenshots are for your reference.

Regards,

Anshu

[micheledenardi]

Yes, 

instead 0 or 1 you have to insert a formula based on the current selection of specific field which recalculate 0 or 1.

[Ame]

@malyadri1004 

Hi, on the table properties option go to the presentation tab and select column picker options and then on the right side of the table scroll down in the column picker to see which columns are visible and which are not, you can resize the table based on the columns you want to show/hide.