Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null Display

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!!!

QVW.png

6 Replies
vinay_hg
Creator III
Creator III

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.

ecolomer
Master II
Master II

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

sushil353
Master II
Master II

Hi,

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

HTH

Sushil

Not applicable
Author

Hi Sushil ,

Thanks for reply !

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

Regards

Saurabh

Not applicable
Author

Thanks for reply Enrique. PFA Image.

Capture.JPG.jpg

Regards,

Saurabh

Not applicable
Author

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