Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
3 Keynotes, 100+ Breakout Sessions, 1 New York Times bestseller, and you. QlikWorld Online, May 10-12: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
malyadri1004
Contributor
Contributor

Hide Column/Show Column in QlikSense based on filter selection

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 amountPaid 7 DPaid 15 DPaid 30DPaid 45 D
10010254979
20045677890
30050100150200
40095150230315
500300320370450

 

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

Labels (1)
5 Replies
JordyWegman
Partner
Partner

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

Work smarter, not harder
micheledenardi
Specialist II
Specialist II

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
Partner
Partner

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
Specialist II
Specialist II

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
Contributor III
Contributor III

@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.