Calculation in script

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

Hi ,

We need to calculated an logic in edit script.Please find below.

Logic:

sum(ESIGN_COMPLETE_NEW)/sum(ToTAL_ORDERS_DAILY_NEW)

Script:

LOAD A7AJCD,

A7AACD,

A7AIDT,

ESIGN_COMPLETE_NEW,

APA0TX

FROM

[F\QVD\Marketing\eSign\Daily_eSign.qvd]

(qvd);

LOAD A7AJCD,

A7AACD,

A7AIDT,

TOTAL_ORDERS_DAILY_NEW,

APA0TX

FROM

[FQVD\Marketing\eSign\Daily_Total.qvd]

(qvd);

Thanks..

Re: Calculation in script

vishsaggi — Tue, 20 Dec 2016 21:19:46 GMT

May be this?

LOAD A7AJCD,

A7AACD,

A7AIDT,

ESIGN_COMPLETE_NEW,

APA0TX

FROM

[F\QVD\Marketing\eSign\Daily_eSign.qvd]

(qvd);

Concatenate(A)

LOAD A7AJCD,

A7AACD,

A7AIDT,

TOTAL_ORDERS_DAILY_NEW,

APA0TX

FROM

[FQVD\Marketing\eSign\Daily_Total.qvd]

(qvd);

LOAD A7AJCD,

A7AACD,

A7AIDT,

APA0TX, Sum(ESIGN_COMPLETE_NEW)/Sum(TOTAL_ORDERS_DAILY_NEW) AS NewTotals

Resident A

GROUP BY A7AJCD, A7AACD, A7AIDT, APA0TX;

DROP TABLE A;

topic Re: Calculation in script in QlikView

Calculation in script

Re: Calculation in script