topic if condition does not work with multiple choices in QlikView

if condition does not work with multiple choices

Wed, 06 Apr 2011 14:03:51 GMT

Hi!

I have problem with an if statement.

i have a chart with invoicenumber as a dimension and in my expression i want it to give me a value if the invoices is connected to a bookkeeping account.

so in my case i write =if(bk_account='1401','Yes','No')

and it returns "No" even if the invoicinumber IS connected to a bk account.

The only thing i can come up with is that this has to be because there's several bk_accounts connected to the invoice.

Am i right? And in that case, how do i solve my problem?

Thanks in advance!

//A.

if condition does not work with multiple choices

Wed, 06 Apr 2011 14:22:41 GMT

Hi,

Can you attach the application?

Thanks & Regards

Jai

if condition does not work with multiple choices

tresB — Wed, 06 Apr 2011 14:23:50 GMT

there could be several options, try this:

IF(Count(IF(bk_account=1401,'Yes','No'))>0,'Yes', 'No') // somewhat like checking existance

does EXISTS() help otherwise?

Regards, tresesco

if condition does not work with multiple choices

Wed, 06 Apr 2011 14:25:19 GMT

if bk_account is a number you don't need the quotes around it

SV:Re: if condition does not work with multiple choices

Wed, 06 Apr 2011 14:32:01 GMT

i have to put the exists in the script right? because i do this in the expression in a chart...

the one you provided with the "count" didn't work unfortunately.

And also, i've tried with and witout the quotes around 1401.

SV:Re: if condition does not work with multiple choices

tresB — Wed, 06 Apr 2011 14:35:25 GMT

Sorry, there is a mistake in my previous expression. please try this:

IF(Count(IF(bk_account=1401,'Yes'))>0,'Yes', 'No')

Regards, tresesco

SV:Re: SV:Re: if condition does not work with multiple choices

Wed, 06 Apr 2011 15:01:57 GMT

Thanks! It worked!

/A.