Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I am a Qlikview Learner, After loading the data into pivot table one row it showing 'empty'.
How to remove that one. I have applied "Supress null vaule option also" but it'not remove.
Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 |
---|---|---|---|---|---|---|---|
Date | Employee | Sal | Dept | loc | State | country | postalcode |
12/05/2017 | Raju | 2000 | IT | Bangalore | KA | Indian | 560037 |
How to remove null row in Pivot table.
Applied "Supress null vaule option also"
Thanks,
Hi,
i don't see any empty row in your above sample data. by default if the table all column has null/ no value then it suppress it while loading it self. my be u can try this method also to enable check box "Suppress when Value is null" in your pivot table chart dimension field
also u can try to enable "suppress zero value" and suppress missing" in your pivot chat object --> presentation tab.
it still not working, would be able to share your mock data with app. thanks
and
THanks
Deva
Can you share sample app?