How to remove Null row in Pivot Table

[Anonymous]

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,

[devarasu07]

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

[neha_shirsath]

Can you share sample app?