topic Re: Hide a row with no data in pivot table based on Multibox field selection in QlikView

Hide a row with no data in pivot table based on Multibox field selection

Tue, 24 Feb 2015 22:34:55 GMT

Hello experts,

As per my project requirement, I havemutibox( categories, style,compnies,..etc)I want to hide only company A,B from list of companies @multibox-> companies,becuase there is no data for these A&B companies.itsshowing blank row at Pivot table. How to block or hide only there twocompnies.

Thanks

Re: Hide a row with no data in pivot table based on Multibox field selection

Anonymous — Tue, 24 Feb 2015 23:06:20 GMT

try,

if(companies<> A or companies<>B,companies)

Re: Hide a row with no data in pivot table based on Multibox field selection

Thu, 26 Feb 2015 16:17:24 GMT

Hello Janet,

Thank you very much for your reply. pleaselet me know where do you wnat me to add this script. is it while loading the data from qvd?

Re: Hide a row with no data in pivot table based on Multibox field selection

menta — Thu, 26 Feb 2015 16:39:15 GMT

Suppress zero value in pivot table settings

Re: Hide a row with no data in pivot table based on Multibox field selection

buzzy996 — Thu, 26 Feb 2015 16:42:05 GMT

u can try,

1.Dimension tab-select for which dimension you are having null values -Select check box "Supress when values is null"

Re: Hide a row with no data in pivot table based on Multibox field selection

Thu, 26 Feb 2015 17:06:27 GMT

Hello Shiva,

This is not writing any NULL values, those are showing Zeros ("0") . I dont want to see those company A , Company B from either my Multibox not Pivot table. FYI: those companies names are not comining from DB, those are loading from INLINE table. how to filter them to not to show in Multibox & pivot table?

Thanks for your help.

Re: Hide a row with no data in pivot table based on Multibox field selection

Thu, 26 Feb 2015 17:07:01 GMT

Hello Everyone,

Thanks for your help!

This is not writing any NULL values, those are showing Zeros ("0").Idontwant to see thosecompanyA,Company B from either my Multibox not Pivot table. FYI: those companies names are notcominingfrom DB, those are loading from INLINE table.howto filter them to not to show in Multibox & pivot table?

Thanks

San

Re: Hide a row with no data in pivot table based on Multibox field selection

buzzy996 — Thu, 26 Feb 2015 17:14:42 GMT

try like this,

load ur inline table into another table by using resident and use where clause where company/ur dimension field <>0 ;