Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
HI @anushree1 you said adhoc report, so you must be having a data island for Dimension and separate one for Expression right?