topic Re: if and expression in QlikView

if and expression

samuel_brierley — Tue, 21 Jan 2014 15:54:29 GMT

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 — Tue, 21 Jan 2014 15:58:01 GMT

You need an and in between the two:

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

Hope this helps!

iktrayanov — Tue, 21 Jan 2014 15:58:06 GMT

Try this

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

alexandros17 — Tue, 21 Jan 2014 15:59:58 GMT

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 — Tue, 21 Jan 2014 16:00:40 GMT

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