topic Null value in QlikView

Null value

Wed, 30 Apr 2014 11:28:11 GMT

Hi,

I have a requirement, where i need to display the top users in a straight table. but issue here is some of the usename's are null and has userid's and in such case instead of username i have to display the user id in the table than showing null username.

Thanks in advance.

Re: Null value

MK_QSL — Wed, 30 Apr 2014 11:30:04 GMT

In your script .. .use below instead of username

IF(Len(Trim(username))=0,'No Name' & [user id], usename) as username,

Now you can show it by username

Re: Null value

its_anandrjs — Wed, 30 Apr 2014 11:33:12 GMT

If you dont want to show null values then use below script

if( Len(trim(username)) > 0 , userid )