I use wildmatch to filter out the waste line. But I get discrepancies with what I filter in excel with my hands. In the click after filtering
Where not wildmatch(Filed_1,'G*','OPA_A','OPA_R','OPA_PP','D110*') and not WildMatch("Field_2",'WAS*') ------> gives me 165 fretchet lines if i do the same filter in excel file i will get 450K lines
Where did another 300k lines disappear in a qlick ?
I found the solution: everything will work if I use the following exspression :
Where wildmatch(Filed_1,'G*','OPA_A','OPA_R','OPA_PP','D110*')=0 and [Field]<> 'exact value' and [Field]<>'exact value' and [Field]<>'exact value' and [Field]<>'exact value'
Or another way to solve this problem is to download your data using csv-file.using this method, you don't have to change anything in the expression : Where not wildmatch(Filed_1,'G*','OPA_A','OPA_R','OPA_PP','D110*') and not WildMatch("Field_2",'WAS*') ------> and its works !
It's great that it works, but I do not know the reason why this happens. Maybe you could explain it ?
in this case do reverse engineering. check those value present in excel & not in qlik. that will help you to find solution.
Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
I found the solution: everything will work if I use the following exspression :
Where wildmatch(Filed_1,'G*','OPA_A','OPA_R','OPA_PP','D110*')=0 and [Field]<> 'exact value' and [Field]<>'exact value' and [Field]<>'exact value' and [Field]<>'exact value'
Or another way to solve this problem is to download your data using csv-file.using this method, you don't have to change anything in the expression : Where not wildmatch(Filed_1,'G*','OPA_A','OPA_R','OPA_PP','D110*') and not WildMatch("Field_2",'WAS*') ------> and its works !
It's great that it works, but I do not know the reason why this happens. Maybe you could explain it ?
