topic Re: pick & wildmatch in QlikView

pick & wildmatch

Fri, 27 Mar 2015 15:22:10 GMT

Hello,

I was wondering if you can help me to fix the following code:

,pick(wildmatch([Transaction Type],'A', 'B' , 'C')+1,[Transaction Type],'A1', 'B1', 'C1') as [Transaction Type.t]

;

How to change the code so A & B would be together under A1 ?

Re: pick & wildmatch

Anonymous — Fri, 27 Mar 2015 15:24:32 GMT

,pick(wildmatch([Transaction Type],'A', 'B' , 'C')+1,[Transaction Type],'A1', 'A1', 'C1') as [Transaction Type.t]

Re: pick & wildmatch

sunny_talwar — Fri, 27 Mar 2015 15:26:03 GMT

What do you mean when you say A & B would be together under A1? Can you elaborate a little more.

Best,

Sunny

Re: pick & wildmatch

Fri, 27 Mar 2015 15:35:42 GMT

I think it solves the problem.

so if i have A, B, C, D,E, F as transactions and want them to be in 3 groups - A1, A2, A3 - how would you solve that? (AB) (CD)(EF)

how to set up the underlined part?

,pick(wildmatch([Transaction Type],'A', 'B' , 'C,'D', 'E' , 'F')+1,[Transaction Type],'A1', 'B1', 'C1') as [Transaction Type.t]

Re: pick & wildmatch

Anonymous — Fri, 27 Mar 2015 15:40:27 GMT

You didn't say how you want to group them, so I assume: A & B to A1, C & D to B1, E & F to C1

(and, I removed the unnecessary parts)

,pick(wildmatch([Transaction Type],'A', 'B' , 'C,'D', 'E' , 'F'), 'A1','A1','B1','B1', 'C1','C1') as [Transaction Type.t]

Re: pick & wildmatch

Fri, 27 Mar 2015 15:42:27 GMT

Thank you. yes. I edited my response but you guessed correctly and I see the logic and how it flows now and will be able to solve my problem. Thank you.