Load when inline

[Anonymous]

Hello,

Is het possible to use a when-claus inside a load?

For example i have a chart whit the following data:

Establishment	Amount
Alkmaar	2000
Alkmaar	2500
Amsterdam	5000
Amsterdam	3500
Alkmaar	1500

In the script i would like to load the average amount bij Establishment; Alkmaar 6000 and Amsterdam 8500.

The result of the script is a table as shown below:

Alkmaar.Averange	Amsterdam.Average
6000	8500

I have tried and played with a load like:

LOAD

SUM ({< Establishment={'6'} >} (Amount/12)) AS [Alkmaar.Average],

SUM ({< Establishment={'7'} >} (Amount/12)) AS [Amsterdam.Average]

FROM

D:\Qlikview\10_Datacloud\Datacloud\Marktmonitor.qvd (qvd);

But i will nog work.

I think it is not that dificult, can someone help me?

Thanks in advance!

[#2]

Hi

Note: Set analysis expressions cannot be used in the load script

I would do it like this:

LOAD     Establishment

, Sum(Amount) AS Total_Amount

FROM nnnnnn.QVD (qvd)

GROUP BY Establishment;

[jagan]

Hi,

Please find attached file. Hope it helps you.

Regards,

Jagan.