Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Match Function Error

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

Tags (1)
1 Solution

Accepted Solutions

Re: Match Function Error

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

15 Replies

Re: Match Function Error

Try with this:

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

let me know

Not applicable

Re: Match Function Error

Thanks for response

Still its not working

Re: Match Function Error

Try with wilmatch instead of match and let me know

Not applicable

Re: Match Function Error

No still showing the same

Re: Match Function Error

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

Not applicable

Re: Match Function Error

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

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

jyothish8807
Honored Contributor II

Re: Match Function Error

Hi Pavan,

Try like this:

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

Hope it works.

Regards

KC

Best Regards,
KC
Not applicable

Re: Match Function Error

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

Community Browser