topic Re: Hiding null value at dimension level in Pivot table in QlikView

Hiding null value at dimension level in Pivot table

sarfaraz_sheikh — Thu, 09 Apr 2015 09:32:42 GMT

Dear All,

In my below image i do not want below Delhi in Ergo_loc as dimension..However i want to show blank values column like FNon_contactable ,ELead_pending without underwriter ..but i do not want in Ergo_loc...I tried but failed..

Kindly help if any solution ....My qvw is also attached here for your refernece ...

Sarfaraz

Re: Hiding null value at dimension level in Pivot table

sarfaraz_sheikh — Thu, 09 Apr 2015 10:14:03 GMT

kindly reply if know the solution ..........

Sarfaraz

Re: Hiding null value at dimension level in Pivot table

pokassov — Thu, 09 Apr 2015 10:21:48 GMT

Hello!

Can you change ERGO_LOC as dimension to calculated dimension

=if(IsNull(ERGO_LOC),' ',ERGO_LOC)

with lable

ERGO_LOC ?

Re: Hiding null value at dimension level in Pivot table

sarfaraz_sheikh — Thu, 09 Apr 2015 10:26:49 GMT

did not work ....have observation in below image...

sarfaraz

Re: Hiding null value at dimension level in Pivot table

awhitfield — Thu, 09 Apr 2015 10:48:25 GMT

The - values are actually 'MISSING rather than 'NULL'

Andy

Re: Hiding null value at dimension level in Pivot table

sarfaraz_sheikh — Thu, 09 Apr 2015 10:51:33 GMT

Dear Andrew,

How to suppress that missing ....any help would be more appreciated

Sarfaraz

Re: Hiding null value at dimension level in Pivot table

awhitfield — Thu, 09 Apr 2015 10:57:54 GMT

If you tick 'Populate Missing Cells' on the presentation tab they will appear as blank instead of -

Re: Hiding null value at dimension level in Pivot table

sarfaraz_sheikh — Thu, 09 Apr 2015 12:17:03 GMT

dear anderw ,

id did not work .......want to hide missing cell ....

sarfaraz

Re: Hiding null value at dimension level in Pivot table

pokassov — Thu, 09 Apr 2015 12:23:04 GMT

I don't get what you want...

Re: Hiding null value at dimension level in Pivot table

Thu, 09 Apr 2015 12:27:57 GMT

Hi,

Please check 'Suppress when value is null' for ERGO_LOC dimension. It should work.

Re: Hiding null value at dimension level in Pivot table

Thu, 09 Apr 2015 12:31:35 GMT

Sorry. My bad.. I did not see the issue properly.

Re: Hiding null value at dimension level in Pivot table

priyarane — Thu, 09 Apr 2015 12:46:19 GMT

Not able to understand your requirement properly.

Re: Hiding null value at dimension level in Pivot table

sarfaraz_sheikh — Thu, 09 Apr 2015 13:16:21 GMT

Dear ceprew,

In this format there is Two dimension 1> Ergo_loc 2> Status_Description

My requirement is very clear i.e i want to keep the 0 values column according to status description...but do not want to keep the null blank as per Ergo_loc

The below screeshot will clear every doubt.. I want like below!

I dont want like below screeshot.

just want to remove the blank record appearing in Ergo_loc dimension .........do not want to remove blank recored as per status description .......

Sarfaraz

Re: Hiding null value at dimension level in Pivot table

sarfaraz_sheikh — Thu, 09 Apr 2015 13:45:03 GMT

hi gwassenaar please comment !!!!!!

Sarfaraz

Re: Hiding null value at dimension level in Pivot table

priyarane — Thu, 09 Apr 2015 13:47:58 GMT

Hi Sarfraraz,

In the dimension tab there is option 1. check surpress when null values and 2. Presentation Tab - Null symbol Value: -(Remove this), Missing Symbol: - (Remove this)