if and expression

[samuel_brierley]

Hi ive tried to make an if and stement in qlikview and its resulting in what ever the second condition is only.

any help?

its suppposed to show all assignents that are on the STSS contract and are open

if(Contract = 'STSS', Status = 'Open', Assignment)

[jerem1234]

You need an and in between the two:

if(Contract = 'STSS' and Status = 'Open', Assignment)

Hope this helps!

[iktrayanov · Accepted solution]

Try this

if(Contract = 'STSS' and Status = 'Open', Assignment)

[alexandros17]

The mistake is that you can't assign a value to a variable in that way:

if you need to seta a variable:

LET myVar = if(Contract = 'STSS', 'Open', 'Other')

hope it helps

[samuel_brierley]

thanks, such a pain getting to know wlikview, doesnt seem to be consistent, eg the and isnt required in a sum expression.