Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Its hard to understand your issue. Please explain in other words. What is the expected output of you hand written table?
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
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.
It seems seven to nine conditions in your data, you can write nested if() to achieve this.
Can you please share logic, 2 nested if
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