Load when inline

Anonymous — Wed, 17 Jul 2013 14:31:14 GMT

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!

Re: Load when inline

Wed, 17 Jul 2013 14:44:13 GMT

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;

Re: Load when inline

jagan — Wed, 17 Jul 2013 15:16:18 GMT

Hi,

Please find attached file. Hope it helps you.

Regards,

Jagan.

topic Re: Load when inline in QlikView

Load when inline

Re: Load when inline

Re: Load when inline