If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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|
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
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.
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:
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.
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.