topic Re: Match Function Error in QlikView

Match Function Error

Fri, 24 Oct 2014 10:15:53 GMT

Hi Friends,

I am using the code Mathc(xxx,01,02,03) to get values related to only 01, 02 and 03 respective.

But its alos giving values related to 00 also.

Should I add anything to remove 00 from filters.

Thanks

Pavan

Re: Match Function Error

alexandros17 — Fri, 24 Oct 2014 10:17:35 GMT

Try with this:

match(xxx,'01','02','03')

let me know

Re: Match Function Error

Fri, 24 Oct 2014 10:22:31 GMT

Thanks for response

Still its not working

Re: Match Function Error

alexandros17 — Fri, 24 Oct 2014 10:24:59 GMT

Try with wilmatch instead of match and let me know

Re: Match Function Error

Fri, 24 Oct 2014 10:30:45 GMT

No still showing the same

Re: Match Function Error

MarcoWedel — Fri, 24 Oct 2014 10:35:28 GMT

How do you use this function (in which context)?

Match(xxx,01,02,03) will return 0 indeed, if there is no matching value. Maybe that's the reason for getting/matching 00, when actually there is no match.

hope this helps

regards

Marco

Re: Match Function Error

Fri, 24 Oct 2014 10:39:24 GMT

Hi Wedel,

I am using this in a pivot table for caluculated dimention. XXX is one my dimention.

I want to see only records matching 01 and 02 in the pivot table. I used the function num(xxxx,00) while loading. and num(match(xxxx,01,02),00) in caluculated dimention.

But here I am getting 00 values also.

Thanks

Pavan

Re: Match Function Error

MarcoWedel — Fri, 24 Oct 2014 10:54:30 GMT

like I thought. Match returns 00 not because it could match to this value, but because it couldn't match any value and therefore returned 0.

Use

If(match(xxxx,01,02),xxxx)

instead

hope this helps

regards

Marco

Re: Match Function Error

jyothish8807 — Fri, 24 Oct 2014 10:57:51 GMT

Hi Pavan,

Try like this:

If(match(xxxx,01,02)>0,XXXX)

Hope it works.

Regards

Re: Match Function Error

Fri, 24 Oct 2014 11:18:27 GMT

Thanks Wedel

It works But one more problem. I added another field 'Agent Number' which is a primary key.

I am geeting all the values of primary key into pivot table.

I want 'Agent Number' into piovt table only if XXX is equal to 01 and 02.

Thanks

Pavan

Re: Match Function Error

Fri, 24 Oct 2014 11:18:41 GMT

Thanks Wedel

It works But one more problem. I added another field 'Agent Number' which is a primary key.

I am geeting all the values of primary key into pivot table.

I want 'Agent Number' into piovt table only if XXX is equal to 01 and 02.

Thanks

Pavan

Re: Match Function Error

jyothish8807 — Fri, 24 Oct 2014 11:24:40 GMT

Hi Pavan,

In dimension write:

Only({<XXXX={01,02}>}Agent Number)

Regards

Re: Match Function Error

Fri, 24 Oct 2014 11:24:56 GMT

The Problem is Its not displaying 00 but displaying balnks instead.

Re: Match Function Error

jyothish8807 — Fri, 24 Oct 2014 11:30:51 GMT

Then do this:

If(match(xxxx,01,02)>0,XXXX,'00')

Regards

Re: Match Function Error

Fri, 24 Oct 2014 11:41:12 GMT

Hi Wedel/Jyothish

Thanks

My problem solved.

Re: Match Function Error

Fri, 24 Oct 2014 11:52:08 GMT

Hi Wedel,

I used If(match(xxx,01,02),xxx). Now all the values which are not matching are gouped into one and giving me total at the last row as blank total.

I dont want any of the non-matching values.

Thanks