topic Re: Can you find the error in this Expression in QlikView

Can you find the error in this Expression

Fri, 10 Oct 2014 03:05:49 GMT

Dear All,

My expression is as follows.

alt(sum({<Cat={'BR'},POSI={'ME'},BRO_COMM={'0'},AGE_COM={'0'},GRO_COM={'0'}>}COM_PRE*BR_COM_ORC)/100,0)

This is working formula for my application. But by using this, calculation is being done for the rows which category ='AG' and 'GR' instead of 'BR'.

As I'm new for qlik view, expected kind help to modify this formula.

Quick response highly appreciated.

Regards,

Priyantha.

Re: Can you find the error in this Expression

Fri, 10 Oct 2014 03:34:04 GMT

Apparently it is seem that other checks in your expression are making condition false , you should check expression by simplifying your conditions. Check what happens when you apply only Cat condition then move on step by step. Or post sample application so that i can check it.

Re: Can you find the error in this Expression

Anonymous — Fri, 10 Oct 2014 03:37:24 GMT

Hi,

Try something like below: if you want to calculate only when those conditions met,

sum(if ((Cat=('BR') and POSI=('ME') and BRO_COMM=('0') and AGE_COM=('0') and GRO_COM=('0')), COM_PRE*BR_COM_ORC,0))/100

Hope this helps.

Regards,

Chinna

Re: Can you find the error in this Expression

Fri, 10 Oct 2014 04:02:13 GMT

Dear Priyantha,

Please post sample data related to this or either try to simplify the expression .

Check the expression step by step with one condition only and add on the conditions one by one.

Thanks & Regards

Prince Anand