Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik experts,
I have already created the columns vBreach and vMisconduct, 1 means true and 0 stands for false.
I am wondering if there is possibility to create the third column MNBR for all 1s?
vBreach | vMisconduct | MNBR |
1 | 0 | Breach |
1 | 0 | Breach |
0 | 1 | vMisconduct |
1 | 0 | Breach |
0 | 1 | vMisconduct |
0 | 1 | vMisconduct |
Thanks in advance!
Please try:
Data:
Load *,
pick(Match(vBreach&vMisconduct,10,01,),'Breach','vMisconduct') as MNBR_Test;
Load * Inline [
vBreach,vMisconduct
1,0
1,0
0,1
1,0
0,1
0,1
];
If the post you received was what you needed, be sure you return to the thread and on that user's post, use the Accept as Solution button to mark that as the solution, which gives the poster credit for the help and lets other Members know that worked.
The only other thing I can offer is a Design Blog post that may also be an option to consider:
https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192
Here is the base URL for the Design Blog area for future reference, as there are over 700 posts there, mostly how-to material that should be helpful to you.
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett