topic Re: EXPRESSION ERROR. in QlikView

EXPRESSION ERROR.

Sat, 25 Apr 2015 04:51:14 GMT

Dear Experts,

Just i wanted to calculate the 'BRO_COMM','AGE_COMM' and 'GRO_COM ' in my pivot table. Just help me to do one of this as i'm learner in Qv.

I have used following expression to calculate the 'AGE_COMM'.

IF(CAT='AG' AND CLA_CODE='PP' AND RANGE1<PREMIUM>RANGE2),SUM(AGE_COM)

Can you any one show me the mistake i have done in my expression.

Sample file is attached herewith.

Rgds,

Priyantha.

Re: EXPRESSION ERROR.

Sat, 25 Apr 2015 04:59:09 GMT

Dear All,

I want to check following the arguments in my logic,

CAT='AG',

CLA_CODE='PP',

and PREMIUM should be in between RANGE1 and RANGE2.

Rgds,

Priyantha

Re: EXPRESSION ERROR.

PrashantSangle — Sat, 25 Apr 2015 05:11:27 GMT

Hi,

Try below

IF(CAT='AG' AND CLA_CODE='PP' AND RANGE1<PREMIUM And PREMIUM>RANGE2),SUM(AGE_COM)

Sum(IF(CAT='AG' AND CLA_CODE='PP' AND RANGE1<PREMIUM And PREMIUM>RANGE2),AGE_COM)

Regards

Re: EXPRESSION ERROR.

Sat, 25 Apr 2015 06:14:21 GMT

Dear Max,

Expected output not achieved,

1st two arguments were achieved but 3rd one not successful.

Anyway thanks lot for the grate help .

Priyantha

Re: EXPRESSION ERROR.

PrashantSangle — Sat, 25 Apr 2015 06:30:11 GMT

Hi,

What was the issue??

It is working in your example you are using Sum inside sum() which qlikview not allowed therefore it is giving error.

but if you modify as

SUM(IF(CAT='AG'AND CLA_CODE='PP' AND RANGE1<Column(1) and Column(1)>RANGE2,AG_COM /100))

It will not give you error.

Regards

Re: EXPRESSION ERROR.

robert_mika — Sat, 25 Apr 2015 06:50:57 GMT

I am using PE (can not open your file) so this is my approach

=sum(IF(CAT='AG' AND CLA_CODE='PP' AND Range1>1 AND Range2<3,AGE_COM))

Re: EXPRESSION ERROR.

ToniKautto — Sun, 26 Apr 2015 07:43:28 GMT

This is a duplicate of your thread Error in Expression

Please avoid duplicating your question, to make it easier for any one trying to help out. I have closed this thread.