topic Expression convert to Load script become not working ? in QlikView

Expression convert to Load script become not working ?

paulyeo11 — Sat, 07 Sep 2019 07:40:22 GMT

Hi All

I have a load script which i mark // which is not working.

sales:
LOAD
'PMC' as SOURCE,
[Row Total],
[Price Currency],
[Price Currency] as CURRENCY,
// Sum([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) as sales,
Quantity AS [quantity],
[Manufacturer Name (Brand)] AS BRAND_RAW,
[Manufacturer Name (Brand)] AS BRAND_,
Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/YY/YYY') as [date],
[Product Code] AS PRO_CLASS

FROM
[C:\Users\Paul Yeo\Dropbox\QLIK_SAP\DEVELOPMENT_QV\ask\TDS.xlsx]
(ooxml, embedded labels, table is TDS);

When i apply below expression at Table 1 it work fine :-
Sum([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

Hope some one can share with me where go wrong ?

Paul Yeo

Re: Expression convert to Load script become not working ?

paulyeo11 — Sat, 07 Sep 2019 07:41:38 GMT

Hi All Enclosed my QVW for your ref.

Re: Expression convert to Load script become not working ?

Vegar — Sat, 07 Sep 2019 10:49:10 GMT

Sum() is an aggregatet function and you will need to point out over which dimensions you want to do the aggregation with a GROUP BY .

I suspect that you don't need the sum. Try this instead:

[Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1) as Sales,

Re: Expression convert to Load script become not working ?

paulyeo11 — Sat, 07 Sep 2019 13:49:56 GMT

Hi Sir

thsnk you very much it work now

Re: Expression convert to Load script become not working ?

Vegar — Sat, 07 Sep 2019 15:25:28 GMT

Thats sounds great.

Glad to help.