EXPRESSION ERROR.

[#1]

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.

[#2 · Accepted solution]

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

[PrashantSangle]

Hi,

Try below

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

or

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

Regards

[#4]

Dear Max,

Expected output not achieved,

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

Anyway thanks lot for the grate help .

Priyantha

[PrashantSangle]

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

[robert_mika]

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))

[ToniKautto]

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.