topic Re: Adding multiple if statements in a ValueList in QlikView

Adding multiple if statements in a ValueList

Wed, 22 Oct 2014 15:23:58 GMT

Hi guys,

I'm looking to add multiple 'if not' statements to a Valuelist. I currently have a valuelist that looks for orders in a particular status, but would like one to look for orders that do not have a status of 'F' or 'S'... The code I have for the single status is as follows...

=if( vShowQty = 1,

If(Valuelist('PriorYear', 'Budget', 'CurrentYear')='CurrentYear',
sum({$ <[Sales.Year]={'2014/15'}, [OrderStatus]={'F'}>} OSQTY),0)

,

If(Valuelist('PriorYear', 'Budget', 'CurrentYear')='CurrentYear',
sum({$ <[Sales.Year]={'2014/15'}, [OrderStatus]={'F'}>} OSValueGBP),0)
)

Thank you in advance

Andrew

Re: Adding multiple if statements in a ValueList

maxgro — Wed, 22 Oct 2014 17:44:15 GMT

use -

example

=sum({$<City=-{Paris,London,Tokyo}>} id)

[OrderStatus]=-{F,S}

Re: Adding multiple if statements in a ValueList

Thu, 23 Oct 2014 08:43:33 GMT

Hi Massimo,

Thanks for your answer!

I did already try this method, but I couldn't get it to work.... There is an error in the syntax apparently. It works in this method like this...

[OrderStatus]={'F','S'}

But not with the 'not equals' in....

Thanks

Re: Adding multiple if statements in a ValueList

jonathandienst — Thu, 23 Oct 2014 09:07:00 GMT

I assume you're talking about the red squiggle underline. This is a bug in the expression editor for implicit set operations.

[OrderStatus]-={'F','S'}

is legal, despite the error indication.

If you prefer to not have the error warning, you can write the equivalent logic written with an explicit set operation:

[OrderStatus]={'*'} - {'F','S'}

HTH

Jonathan

Re: Adding multiple if statements in a ValueList

anbu1984 — Thu, 23 Oct 2014 09:10:11 GMT

You might see red lines appeared in your expression after you added minus. Are you saying syntax error because of red lines or you got "Error in expression"?