topic Re: Handling Null fields values in QlikView

Handling Null fields values

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

Hi QlikExperts,

I have below table

Name Role

Alice Territory_Manager

Bob Zone_Manager

If in Role - Territory_Manager , Name - Alice is not there then against Role - Zone_Manager I should get Name - BOB

Please help.

Also find attached image for more clarification.

Thanks in advance.

Re: Handling Null fields values

Vegar — Sat, 11 Jul 2020 14:28:23 GMT

Its hard to understand your issue. Please explain in other words. What is the expected output of you hand written table?

Re: Handling Null fields values

Anonymous — Sun, 12 Jul 2020 05:52:19 GMT

Your question is not much clear but answering as per my understanding, when Territory_Manager roles is not filled by Alice then Zone_manger name will be BOB. Please check below conditon.

=If(Role='Territory_Manager' and Name<> 'Alice', 'Bob',Name) as New_Name

Re: Handling Null fields values

karunaramteke — Sun, 12 Jul 2020 07:54:57 GMT

Thanks you are close to it, but I have many Names

From attached sheet line 8 in F column, If Name_MCOM is not there then it should take Name : Newbaran Pal which is against Meetingg Center Operation manager.

Please find attachement for more clarity.

Re: Handling Null fields values

Anonymous — Sun, 12 Jul 2020 08:13:30 GMT

It seems seven to nine conditions in your data, you can write nested if() to achieve this.

Re: Handling Null fields values

karunaramteke — Sun, 12 Jul 2020 08:30:00 GMT

Can you please share logic, 2 nested if

Re: Handling Null fields values

Brett_Bleess — Thu, 23 Jul 2020 13:25:04 GMT

Best I can offer is the following Design Blog post that may put you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/Replacing-Null-Values-in-Multiple-Fields/ba-p/1470988

If you want to search further in that area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-bloga

Regards,
Brett