topic Re: choosing from multiple values in formula in QlikView

choosing from multiple values in formula

Tue, 15 Sep 2015 13:06:10 GMT

One of our databases has multiple values for billing a customer:

I wanted to determine if a customer has a monthly fee or not. However, the formula

IF(Per_Bill.PMC_Code='MONTHLY',1,0)

always returns zero. I figure this is because QV sees the two possible values for the PMC_Code,

doesn't know which one to choose, and so evaluates the condition as NULL, and hence the result

is zero.

I've tried multiple combinations of conditions within the IF, to no avail.

Any one know how I might handle this?

thanks,

Kevin

sunny_talwar — Tue, 15 Sep 2015 13:09:04 GMT

Is this an expression or dimension?

Tue, 15 Sep 2015 13:10:18 GMT

It's an expression

sunny_talwar — Tue, 15 Sep 2015 13:15:58 GMT

See if this helps:

If(WildMatch(Concat(Per_Bill.PMC_Code, '|'), '*MONTHLY*'), 1, 0)

Tue, 15 Sep 2015 13:43:26 GMT

Thanks, Sunny, that worked great!

sunny_talwar — Tue, 15 Sep 2015 14:00:12 GMT

Awesome

I am glad it helped. If you got what you wanted, can you close the thread by marking the correct answer and/or any helpful answers.

Best,

Sunny