topic Re: If function with two clauses from different tables (In chart) in QlikView

If function with two clauses from different tables (In chart)

Anonymous — Wed, 07 Aug 2013 13:36:26 GMT

I'm trying to make a simple Sum function, which should be dependent on two "IF" clauses, but for some reason I can't make it work...

The function below should take the sum of [Sales Lines - Net Sales Amount], but only for the lines, which doesn't have either status None from table Sales Line - A or status Cancelled from table Sales Line - B

sum(if([Sales Lines - A] <> 'None' OR [Sales Lines - B] <> 'Cancelled', [Sales Lines - Net Sales Amount]

))

Any ideas?

I also tried to put this data into my script (since I'll be using this variable several times), but I was unsuccesful (Read: Not skilled enough 😉 )

Looking forward to hear from you

Re: If function with two clauses from different tables (In chart)

MayilVahanan — Wed, 07 Aug 2013 13:47:33 GMT

Try like this

= Sum({<[Sales Lines - A] -={'None'}, [Sales Lines - B] -= {'Cancelled'}> }[Sales Lines - Net Sales Amount])

Hope that helps

Re: If function with two clauses from different tables (In chart)

Anonymous — Wed, 07 Aug 2013 13:59:21 GMT

Thank you Mayil

That did exactly what I was looking for.

I didn't know the sum function could be used the way you just did, thanks.