topic Re: Multiple If Statements in QlikView

Multiple If Statements

Wed, 30 Dec 2015 16:34:08 GMT

I have the need to add a condition to a report. Currently there are multiple conditions on the report but for one of the fields I need to add another status type.

Currently it looks like this.

sum({<[Transaction Status] = {'Request Completed'},[Transaction Sold Flag]={'N'},[Active Flag]={'Active'}>}USD)

I need to also include the Transaction status of Held, could I just do this?

sum({<[Transaction Status] = {'Request Completed'},[Transaction Status] = {'Held'},[Transaction Sold Flag]={'N'},[Active Flag]={'Active'}>}USD)

Re: Multiple If Statements

swuehl — Wed, 30 Dec 2015 16:39:03 GMT

Try

sum({<[Transaction Status] = {'Request Completed','Held'}, [Transaction Sold Flag]={'N'},[Active Flag]={'Active'}>}USD)

Re: Multiple If Statements

Clever_Anjos — Wed, 30 Dec 2015 16:39:59 GMT

sum({<[Transaction Status] = {'Request Completed','Held'},[Transaction Sold Flag]={'N'},[Active Flag]={'Active'}>}USD)

Re: Multiple If Statements

Wed, 30 Dec 2015 16:40:00 GMT

Hi Jason,

yes, you can.

if you'll find any difficulties with set analysis then try with normal if condition with "or" function.

Re: Multiple If Statements

swuehl — Wed, 30 Dec 2015 17:14:02 GMT

I don't think that your expression

sum({<[Transaction Status] = {'Request Completed'},[Transaction Status] = {'Held'},[Transaction Sold Flag]={'N'},[Active Flag]={'Active'}>}USD)

will consider both transaction status values, I believe there should be only one field selection per set modifier (i.e. only a one time appearance of [Transaction Status] = ... within <....> ).

Have you tried your expression? And have you tried a field selection with an element set {'Request Completed','Held'} ?

Re: Multiple If Statements

evan_kurowski — Wed, 30 Dec 2015 17:26:20 GMT

Agree with swuehl, who's syntax appears valid the first time. This 'correct' answer needs an NFL's coach's review flag.

Re: Multiple If Statements

Wed, 30 Dec 2015 17:32:44 GMT

LOL, love that the challenge flag just got thrown in on a QlikView community thread.

I will play with the data and see how it works with both. I added the statement that I had first entered in and the data never changed, after further review I found deep in the script that the value 'N" for Transaction Sold Flag is set to N if the Transaction Status is 'Held', so the request from the user was redundant.

Which is why when I entered the new syntax in the results didn't change. Either way I will play with some data and get back to the thread and see which way works, maybe both do.