Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
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.
hope this helps
Try with this:
let me know
Thanks for response
Still its not working
Try with wilmatch instead of match and let me know
No still showing the same
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.
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.
Try like this:
Hope it works.
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.