Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try,
if(companies<> A or companies<>B,companies)
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?
Suppress zero value in pivot table settings
u can try,
1.Dimension tab-select for which dimension you are having null values -Select check box "Supress when values is null"
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.
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
try like this,
load ur inline table into another table by using resident and use where clause where company/ur dimension field <>0 ;