topic Re: Script error calculating the sum of values in QlikView

Script error calculating the sum of values

bhaveshp90 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

My below script gives me an error for Final Acceptance field as shown below.

I am trying to calculate the sum of the calc_delay values where Overview_Milestone_Point = 'Final Acceptance Complete'

Where am I doing wrong here?

Overview_Milestone:

LOAD Project_Number &'-'& Region &'-'& if (match(Country_Name,'US','UK','Canada','SE')>0, Country_Name, Capitalize(Country_Name)) &'-'& Snapshot_Date as Project_Overview_Milestone_Key,

Overview_Milestone_Point,

calc_delay

FROM

(qvd);

Milestone1:

NoConcatenate load

Final_Acceptance = Sum({<Overview_Milestone_Point = {'Final Acceptance Complete'}>}calc_delay)

Resident Overview_Milestone;

drop table Overview_Milestone;

thanks

Bhavesh

Re: Script error calculating the sum of values

rajivmeher — Mon, 10 Sep 2018 17:55:40 GMT

Hi bhaveshp90‌

Shouldn't the Final_Acceptance field be as follows:

NoConcatenate

Milestone1:

load

Sum({<Overview_Milestone_Point = {'Final Acceptance Complete'}>}calc_delay) AS Final_Acceptance

Resident Overview_Milestone;

drop table Overview_Milestone;

If not the case, please can you share the error that you are getting, so that it will be easier to troubleshoot?

Regards

Rajiv.

Re: Script error calculating the sum of values

trdandamudi — Mon, 10 Sep 2018 17:59:04 GMT

May be as below: (Note: I don't think you can use Set Analysis in the script)

Milestone1:

NoConcatenate load

If(Overview_Milestone_Point ='Final Acceptance Complete',[calc_delay],0) as Final_Acceptance

Resident Overview_Milestone;

You can then do the SUM in the front end charts.

Re: Script error calculating the sum of values

santhana — Mon, 10 Sep 2018 18:04:57 GMT

Hi Bhavesh,

Set Expression cannot be written in edit script, you can write in front end

Re: Script error calculating the sum of values

bhaveshp90 — Mon, 10 Sep 2018 18:10:41 GMT

thank you that worked, you are right we cannot use Set-analysis in the script itself