topic Re: How to remove Null row in Pivot Table in QlikView

How to remove Null row in Pivot Table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: How to remove Null row in Pivot Table

devarasu07 — Tue, 05 Dec 2017 10:20:54 GMT

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

Re: How to remove Null row in Pivot Table

neha_shirsath — Tue, 05 Dec 2017 10:39:16 GMT

Can you share sample app?