topic Re: wildmatch in QlikView

wildmatch

pgalvezt — Tue, 26 May 2015 19:55:56 GMT

Hi,

I have many accounts, but I don´t want to fill up qlikview with many IF Sentence. If(cuenta='11' or cuenta='22' so on...

I would like to group that account. So I have This:

100000	Activo
110000	Activo Circulante
110100	Disponible
110101	Cajas
110102	Bancos
110103	Fondos Fijos
110200	Depósitos a Plazo

For example: for "Disponible" ( Cajas + Bancos)

Disponible has the next accounts (Cajas) = 11010101 11010102 11010103 so on

also has The next Accounts (Bancos) = 11010201 11010202 11010203 son on

How I can use wildmatch function for this. I would like something like this: 110101* group all cajas and the group all Bancos and then can get the sum total.

Thanks!

Re: wildmatch

b_garside — Tue, 26 May 2015 20:25:10 GMT

You can combine Wildmatch with Pick function. Wildmatch returns a integer indicating where the match occurred. like an index function. it executes on the outer Pick function even expressions vs simple strings.

If Field = 34 then it will output 'B' . =Pick(WildMatch(23, 23, 34, 45), 'A, P', 'B', 'K')

But you can add far more with less code using the Pick function

Re: wildmatch

sunny_talwar — Tue, 26 May 2015 20:32:49 GMT

I would suggest using WildMatch instead, may be something like this:

=Pick(WildMatch(FieldName, 110101*,110102*), 'Cajas', 'Bancos')

Re: wildmatch

pgalvezt — Fri, 29 May 2015 14:58:11 GMT

=Pick(WildMatch(Letra, 1*,2*), 'A', 'B') as Name

missing a parenthesis. Where goes?

Re: wildmatch

pgalvezt — Fri, 29 May 2015 15:03:07 GMT

I think the sentence was:

Pick(WildMatch(FieldName, '110101*','110102*'), 'Cajas', 'Bancos')

thanks now working.

Re: wildmatch

sunny_talwar — Fri, 29 May 2015 15:22:54 GMT

Hahahaha ya, I did not know if you were using this as an chart expression or using it in the script

I lost 10 points for adding a equals sign , but I am glad you got your solution

Best,

Sunny

Re: wildmatch

pgalvezt — Fri, 29 May 2015 15:31:09 GMT

Hi sunindia

It was not the equal sign. The expression fail too. The solution was good just has to add '110101*','110102*' your solution was 110101*,110102*. just a little detail. thanks!

Re: wildmatch

sunny_talwar — Fri, 29 May 2015 15:33:37 GMT

‌hahaha yes you are right... Didn't realize that I forgot to put the single quotes.

Best,

Sunny

Re: wildmatch

pgalvezt — Fri, 29 May 2015 15:41:07 GMT

No problem! than you for your help.

Re: wildmatch

sunny_talwar — Fri, 29 May 2015 15:42:23 GMT

No problem my friend.