topic Re: null values in QlikView

null values

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Iam using below code in the script to tag all brands which has "Tdepartment" in it , along with this i want eliminate null values

how do i include that in the below script .

if(WildMatch(VM_Model,'*Tdepartment*'),'Tdepartment Only') as Tdepart,

Thans in advance

Re: null values

MindaugasBacius — Wed, 03 May 2017 12:55:10 GMT

May be this would help you:

if(WildMatch(VM_Model,'*Tdepartment*') or Len(Trim(VM_Model)) = 0,'Tdepartment Only') as Tdepart,

Re: null values

Anil_Babu_Samineni — Wed, 03 May 2017 12:58:30 GMT

I didn't understand your intend here. You already written the text search so you have some values with that. What you mean to remove the null values over here. May be use with OR Operator any one of below

If(Len(Trim(VM_Model))>0,VM_Model)

If(Len(Purgechar(VM_Model, chr(32) & chr(160)))>0,VM_Model)

Re: null values

neelamsaroha157 — Wed, 03 May 2017 12:58:50 GMT

May be you can take resident of the table with a where condition: Where not isNull(Tdepart) or use this condition in precedence load.

Re: null values

smilingjohn — Wed, 03 May 2017 13:08:57 GMT

Hi Anil,

I want to remove the null values also here .

Re: null values

MindaugasBacius — Wed, 03 May 2017 13:13:13 GMT

What do you mean by saying "remove"?

Do you need to remove them from your table or change null values to something?

Re: null values

smilingjohn — Wed, 03 May 2017 13:15:28 GMT

Anil please find the attachment

here if you look i am getting a null, values also , i dont know why it is aapearing two time one with Tdepartment Only

(iPerformance Only) and exactly below that its null ,

so i want to remove the null values ...

i hope you understand it now ...

Re: null values

Anil_Babu_Samineni — Wed, 03 May 2017 13:16:25 GMT

May be this? and operator consider as If condition full fills it will returns

if(WildMatch(VM_Model,'*Tdepartment*') and If(Len(Trim(VM_Model))>0,VM_Model),'Tdepartment Only') as Tdepart,

Re: null values

MindaugasBacius — Wed, 03 May 2017 13:23:52 GMT

Are both dimensions from the same table?

Might be something wrong with joins in your data model.

Re: null values

smilingjohn — Wed, 03 May 2017 13:40:25 GMT

Anile i have kept you sugested script to run ( reloading )

can you please tell me what is this going to do ?

Re: null values

smilingjohn — Wed, 03 May 2017 13:40:55 GMT

Hi Mandaugas

They are from different table

Re: null values

smilingjohn — Wed, 03 May 2017 13:58:57 GMT

Hi Anil after the loading of the script now it show completely null values as shown in the script ...

i dont see Tdepartment at all .

Re: null values

Anil_Babu_Samineni — Wed, 03 May 2017 14:15:39 GMT

Would you able to share sample application?

Re: null values

Anil_Babu_Samineni — Wed, 03 May 2017 14:16:11 GMT

Or Can you do Suppress Null value from dimension and Presentation tab may be??

Re: null values

smilingjohn — Wed, 03 May 2017 14:21:14 GMT

Hi Anil,

Yes suppressing works perfectly at the dimesion level ...

But still i wanted to confirm that if i can suppress this values witin the expression in the edit script ?

If you think its not required then it fine ...

Thanks

Re: null values

Anil_Babu_Samineni — Wed, 03 May 2017 14:25:53 GMT

It's possible in script as well. If you would provide sample data we may help you. I would highly recommend you to Mark as helpful or correct answer if you got solution