Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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))
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
Yes,
instead 0 or 1 you have to insert a formula based on the current selection of specific field which recalculate 0 or 1.
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.