topic Re: Hiding null value in QlikView

Hiding null value

sarfaraz_sheikh — Tue, 21 Apr 2015 07:38:25 GMT

Dear All,

look at in below first chart ........Ergo_Location contains null value and I want to suppress it ........but i want to keep the 0 values column like ....BInsurer_reject,ELead_Pending_w/u_underwriter , F_Noncontactable etc.

when i checked the supress when value is null on Ergo_Loc then it will hide the 0 values column also .....But I want to keep o valuese column ....and not to keep null values of Ergo_Loc

And i want the output like below chart

kindly help me with this one ....qvw file is also attached here for your refernece..

Sarfaraz

Re: Hiding null value

mohamed_ahid — Tue, 21 Apr 2015 08:54:23 GMT

HI,

if i got you you want :

to delete all the null columns (from Total_Leads_Considered to MWork_In_Progress) for the empty ergo loc and just for lead % ?

in the sample %lead is always empty . is it normal ?

have tried to use conditionnal calculation over expression ?

Re: Hiding null value

sarfaraz_sheikh — Tue, 21 Apr 2015 09:48:10 GMT

Dear Ahid,

Yes, %Lead is always should be empty for Ergo_Loc dimension ...and should show in total..

I did not tried to use conditional calculation over expression .....

And my requirementr is i want to keep 0 values column in format like below ..........and not to keep null value on Ergo_LoC

Look at below snapshot will clear everthing !!!!!!

The null value of Ergo_Loc has been removed and null columns like E_Lead_Pending_With_U/W , F_Non_Contactable etc are showing there ........This is my requirement....

Sarfaraz

Re: Hiding null value

mohamed_ahid — Tue, 21 Apr 2015 12:37:54 GMT

i this case you are trying to display missing value for ergo loc , in my opinion you schoul either try to add 0 values in your data while loading or try to display the straight table by divising in separate tables (one for dimension and other one for total ) , you can play with backround color to hide what you want to be hided .

Re: Hiding null value

sarfaraz_sheikh — Tue, 21 Apr 2015 13:10:54 GMT

can you keep any example for my inderstanding .......so that it would be more helpful for me

sarfaraz

Re: Hiding null value

mohamed_ahid — Tue, 21 Apr 2015 14:00:51 GMT

here is a try (not well tested )

th idea is inject lines with 0 value . in the attachement you wil see that for the first table i added lines with 0 as id and in the second table i have added (with load distinct statment) lines with 0 as ID and without no values .