topic Re: Error in Expression in QlikView

Error in Expression

Fri, 24 Apr 2015 12:36:43 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: Error in Expression

Fri, 24 Apr 2015 12:37:19 GMT

Urgent....... Please.......!!!

Re: Error in Expression

ankitaag — Fri, 24 Apr 2015 12:58:10 GMT

But this is the expression you have written in your attached application

SUM(IF(CAT='AG',(COM_PRE*AG_COM+SR*AG_RS+TC*AG_TC)/100))

Re: Error in Expression

ankitaag — Fri, 24 Apr 2015 12:59:30 GMT

What is Premium in your mentioned expression?

Re: Error in Expression

buzzy996 — Fri, 24 Apr 2015 13:09:51 GMT

earlier there was a field "AG_RS",i think u changed that field name..no it's not appearing in ur application,just replace ur new field name with AG_RS,then values will reflect.

else u have the different formula,then u can place that.

note: we shared answers on ur earlier posts,seems those not marked...,if ur happy with those answers u can mark as correct.

Re: Error in Expression

Sat, 25 Apr 2015 04:14:15 GMT

I have tried in many ways. may be final one not saved in my attachment.

But this is the last one i tried,

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

in my logic,

CAT='AG',

CLA_CODE='PP',

and PREMIUM should be in between RANGE1 and RANGE2.

Thank for your early reply.

Re: Error in Expression

Sat, 25 Apr 2015 04:15:28 GMT

PREMIUM=SUM(COM_PRE+SR+TC)

Re: Error in Expression

Sat, 25 Apr 2015 04:36:32 GMT

Dear Shiva,

I have closed all the threads i have posted.

Re: Error in Expression

ToniKautto — Sun, 26 Apr 2015 08:02:07 GMT

You have requested urgent help, but your example file does not match your latest details. In order to get quick and accurate assistance you need to provide a proper description of you problem, this includes describing the result you get and the result you are expecting.

From your example file and additional comment I can see that you are not familiar with QlikView as a tool and the expression syntax in particular. For examples if you open the expression editor and there is a red line highlighting any part in the expression, it indicates an incorrect syntax or reference in the expression. As aninitial action I would recommend that you look in the help or reference manual for details on who the function should be defined. If you do not understand how a specific function work, please clarify in your question where you are stuck.

As a beginner it is wise to attend the free online training, so that you get familiar with how QlikView functions as a product. This is essential for your success as a developer. To deepen your knowledge the free training can be followed by virtual or real classroom training.

QlikView Free Training - Business Intelligence (BI) Reporting Software Solutions | Qlik

Re: Error in Expression

Mon, 27 Apr 2015 06:13:28 GMT

Thanks a lot for the instructions and information.

Re: Error in Expression

Mon, 27 Apr 2015 08:06:38 GMT

Dear All,

In my data base there are many products under 'CLA_CODE', within this cla_codes there a many sub products and Those are named as 'PRD_CODE'

Ex:- CLA_CODE PRD_CODE

PP SE

PP SA

PP DD

PP LI

MC 1A

MC 1B

MC 1C Like that,

in 'DD','SE','SA' and 'LI' Prd_code there are different premiums(prices) which are entitled different Commission amounts to the respective marketing force.

Then i have build three arguments in my basic formula,

1st and 2nd arguments are in order(expected output coming)

3rd one is 'RANGE1<PREMIUM<RANGE2'. Even though expression got 'OK',

This is not working as per my testing. Dear friends, please help me to find the mistake i have done or propose an alternative way to do this.

Rgds,

Priyantha.