topic adding 2 different calculations to expression in QlikView

adding 2 different calculations to expression

hopkinsc — Sat, 24 Jul 2010 13:13:17 GMT

I need to do the following...

I have a LIST BOX which displays various DEAL DESCRIPTIONS. Linked to these DEAL DESCRIPTIONS are Sales quantities.

I have created an expression which divides the Sales quantities by 3 when a specific DEAL DESCRIPTION is selected.

This is my expression

If ([Deal Description] = '900000 - P5-P8 MEAL DEAL £3' ,Sum(SalesQuantity))/3

But i need to divide any other DEAL DESCRIPTION by 2.

The reason for this is that the above DEAL DESCRIPTION incorportaes 3 products. But all other DEAL DESCRIPTIONS only incorporates 2 products,

Does anyone know how i would include this in my expression?

Thanks

shumailh — Sat, 24 Jul 2010 13:26:07 GMT

Use the else condition simple


If ([Deal Description] = '900000 - P5-P8 MEAL DEAL £3' ,Sum(SalesQuantity)/3, Sum(SalesQuantity)/2)

Regards,
Shumail Hussain

hopkinsc — Sat, 24 Jul 2010 13:32:10 GMT

Thanks for your reply, But where would i use the ELSE condition.

I have tried copying exactly whats in your example, and tried putting else before the second sum, but it doesn't work??

shumailh — Sat, 24 Jul 2010 14:48:10 GMT

dude copy the exactly same code which i posted earlier. ok

Regards,
Shumail