topic Re: Not Wildmatch function in QlikView

Not Wildmatch function

sindisa12 — Sat, 16 Nov 2024 19:53:06 GMT

Good day.The first part of the expression below does not work when using "not wildmatch" function. I have under Region ABC, Region A, Region B and Region C. Other Regions include D, E, F, G,H,I.

The first "if" statement should calculate the amount * Month3% if Region is D, E,F,G,H,I. The second "if" statement should calculate amount only if Region = A,B or C. This expression calculates correctly but the first one with "not wildmatch" function does not bring the correct results. what other function should i use instead?

if(match(Description,'New') and Line_ID <>20 and not wildmatch(Region, 'ABC*'),
Sum({<Line_ID_2 = {3} >} Amount * only(Month3%),

if(match(Description,'New') and match(Line_ID ,20 ) and wildMatch (Region, 'ABC*'),
sum( Amount),

Re: Not Wildmatch function

sunny_talwar — Wed, 16 Oct 2019 19:22:11 GMT

Not sure if you condition is right or not, but try this for the true condition

Sum({<Line_ID_2 = {3}>} Amount * Month3%)

Re: Not Wildmatch function

sindisa12 — Wed, 16 Oct 2019 19:38:40 GMT

Hi Sunny, I tried the solution and still does not work.

Re: Not Wildmatch function

sindisa12 — Wed, 16 Oct 2019 19:40:01 GMT

Hi Sunny, I tried using your solution and still does not work.

Re: Not Wildmatch function

sunny_talwar — Wed, 16 Oct 2019 19:43:02 GMT

Do you know what isn't working? the condition or the expression?

Re: Not Wildmatch function

sindisa12 — Wed, 16 Oct 2019 19:46:25 GMT

The expression as it is not bringing the desirable results.

Re: Not Wildmatch function

sunny_talwar — Wed, 16 Oct 2019 19:49:39 GMT

Oh so it is bringing a result, just not the one you wanted.... can you provide some information on what you are getting and what you hoped to get?

Re: Not Wildmatch function

shamiul_islam — Thu, 17 Oct 2019 05:06:55 GMT

You can use Resident to calculate the sum where you can use 'NOT EXISTS' function.

Re: Not Wildmatch function

sindisa12 — Thu, 17 Oct 2019 06:25:05 GMT

The value is 800 for Region A, B or C and it should be zero for others. I am trying to avoid adding the parameter Line_ID and multiplying by the month% for this calculation. The first expression is applied even if the Region does not fall under the category.

Re: Not Wildmatch function

sindisa12 — Thu, 17 Oct 2019 06:26:53 GMT

Good day. This is done in the front end expression at the moment as parameters come from different tables.

Re: Not Wildmatch function

sindisa12 — Thu, 17 Oct 2019 10:21:43 GMT

Problem solved. Thank you all for your help

Re: Not Wildmatch function

Brett_Bleess — Wed, 23 Oct 2019 17:51:35 GMT

Emelina, can you post what the final solution was and then use the Accept as Solution button on that post to mark it? I can also mark Sunny's post if that is what ended up working, I just wanted to confirm. You had marked a post that really did not make sense regarding it being the solution, so I unmarked that so as to not confuse folks coming across the post.

Thanks,
Brett