topic Hide rows with null value in Pivot table in App Development

Hide rows with null value in Pivot table

prasadcm — Sat, 16 Nov 2024 21:17:08 GMT

Hello,

I am facing an issue in QlikSense where i need to hide rows with null values in Pivot table.
I have 15 levels..but there is no data for certain levels,like in below image I have data for top 4 levels and at 15th level.
I need to hide all the blank/null rows.
Suppress null value isn't working.

Regards,

Prasad

@sunny_talwar

Re: Hide rows with null value in Pivot table

Anil_Babu_Samineni — Fri, 08 Mar 2019 08:27:30 GMT

Expand the each dimension and UN-tick the "Include null values"

Re: Hide rows with null value in Pivot table

prasadcm — Fri, 08 Mar 2019 12:35:18 GMT

I tried it already,doesn't work

Re: Hide rows with null value in Pivot table

Anil_Babu_Samineni — Fri, 08 Mar 2019 13:11:46 GMT

Please post some sample QVF file to test using work-around.