topic Re: Null Display in QlikView

Null Display

Wed, 24 Sep 2014 03:17:45 GMT

Hi ,

I am facing an issue regarding the null values .i have a link table and a customer rating table .i have to show total no of customer (whether they are rated or not). Ratings are like A,B,C,Unclassified (not Rated).

i have used Left Keep to associate the two tables .

LinkTable:

...

Left Keep

Customer Rating :

dimension:

if(len(Trim(CustomerRating))=0,'Unclassified',CustomerRating)

Expression:

Count(Distinct Cust_Code)

As per the attached image , unclassified are visible at the Qv Desktop but not visible at accesspoint . Users are not able to see unclassified one.

Thanks!!!

Re: Null Display

vinay_hg — Wed, 24 Sep 2014 05:00:12 GMT

have you used supress?

actually if it is displaying in dev it should display in client. pls check the hosted or published file is of same version wat you have.

Re: Null Display

ecolomer — Wed, 24 Sep 2014 05:45:41 GMT

We can see the image, can you reload more big, please

Re: Null Display

sushil353 — Wed, 24 Sep 2014 05:50:30 GMT

Hi,

Test your application in webview mode.. also make sure same copy of dev presents on server..

HTH

Sushil

Re: Null Display

Wed, 24 Sep 2014 07:30:25 GMT

Hi Sushil ,

Thanks for reply !

In Web view mode i can see Unclassified.and same copy of dev is on the server.

Regards

Saurabh

Re: Null Display

Wed, 24 Sep 2014 07:34:45 GMT

Thanks for reply Enrique. PFA Image.

Regards,

Saurabh

Re: Null Display

Wed, 24 Sep 2014 07:45:45 GMT

Hi vinay ,

i have not used Suppress null . i am also confused y so ?

Actually m testing the same app on my local server means on the same pc .if i see the same app in Qv desktop its displaying the unclassified but not on accesspoint.

Regards,

Saurabh