topic Re: Concatenate 2 Columns as a prescribed column in QlikView

Concatenate 2 Columns as a prescribed column

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

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!

Re: Concatenate 2 Columns as a prescribed column

anushree1 — Tue, 04 Feb 2020 05:28:37 GMT

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

];

Re: Concatenate 2 Columns as a prescribed column

Brett_Bleess — Wed, 26 Feb 2020 17:56:23 GMT

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