topic filter columns based on a selection in App Development

filter columns based on a selection

anushree1 — Fri, 03 Dec 2021 11:47:33 GMT

Hi @sunny_talwar @tresB @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

Re: filter columns based on a selection

vikasmahajan — Wed, 08 Dec 2021 14:47:44 GMT

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

Re: filter columns based on a selection

anushree1 — Fri, 03 Dec 2021 12:14:24 GMT

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

Re: filter columns based on a selection

anushree1 — Fri, 03 Dec 2021 13:36:41 GMT

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

Re: filter columns based on a selection

kaushiknsolanki — Fri, 07 Jan 2022 18:48:52 GMT

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