filter columns based on a selection

[anushree1]

Hi @sunny_talwar @tresesco @swuehl @kaushiknsolanki @Vegar ,

I have a table with a long list of dimensions and columns , say for a particular divison not all the columns are applicable so i want to show only the applicable columns of that division in the adhoc report.

So in the attached, Div A has values for m1,m3,m6,m9 and m10 columns whereas other columns are blank so on adhoc column list i would like to see the relevant columns  based on the selected Div, please suggest how this could be done on qliksense.

Please note the columns and rows are very huge in number so would not want the performance to be affected with multiple conditions

[vikasmahajan]

in report you can untick  'Include zero values' under Data Handling -> Add-Ons  this will skip null values

see below post 

https://community.qlik.com/t5/New-to-Qlik-Sense/don-t-show-null-measure-values/m-p/67625#M14200

Regards

Vikas

[anushree1]

My requirement is that on the list of measures(measure list created for adhoc reporting  ) itself i must not see the column as it does not have value for a selected division , you are referring to making sure that the row does not appear, so it does not help

[anushree1]

I have a working solution , wherein i have added another table with Div, dim and measures that can be linked to the excel data via Div field to get the essential columns and using the show hide functionality on the front end.

But the issue is incase ,  we are asked to get relevant measures basis country or a new field department or may be both country and divison  in the later enhancements, things become difficult to manage , hence looking for a much optimized solution

[kaushiknsolanki]

HI @anushree1 you said adhoc report, so you must be having a data island for Dimension and separate one for Expression right?