topic if statement using expressions in QlikView

if statement using expressions

Mon, 10 Dec 2012 16:05:27 GMT

Hi all,

My problem is that I can't make my IF statement to work.

Model of my problem:

My data:

Want to get pivot table:

Price is expression: if([House type]=('A'), $(eSumPrice1), $(eSumPrice2))

My expressions:

eSumPrice1=Sum(Price1)

eSumPrice2=Sum(Price2)

It must be so simple, pls help me ASAP!

Tiv0li

jeffmartins — Mon, 10 Dec 2012 16:26:31 GMT

Hi tiv0li321,

I tried to use your expression and it works for me. Maybe you didn't create the variables eSumPrice1 and eSumPrice2.

See the attached file.

Regards

Gysbert_Wassenaar — Mon, 10 Dec 2012 16:27:30 GMT

In your case you don't need if statements. Just use sum(numsum(Price1,Price2)) instead.

MayilVahanan — Mon, 10 Dec 2012 17:14:07 GMT

Try like this

=RangeSum(Sum(Price1),Sum(Price2))