topic Re: Using expression and functions when doing inline load in QlikView

Using expression and functions when doing inline load

Wed, 08 Apr 2015 16:53:21 GMT

Hi, I'm trying to use an expression in an inline load but having trouble with the right syntax. Can someone please help? Thx!

TableMinMax:

LOAD * Inline

[

tMinNum, tMaxNum

$(=Min(NumberA)),$(=Max(NumberA)),

$(=Min(NumberB), $(=Max(NumberB))

];

LOAD

NumberA,

NumberB

Resident NumberTable;

Gysbert_Wassenaar — Wed, 08 Apr 2015 17:00:52 GMT

It kinda looks like you want to use an inline load as a preceding load. If so, that cannot work. Try this:

TableMinMax:

LOAD

min(NumberA) as tMinNum,

max(NumberA) as tMaxNum,

Resident NumberTable;

CONCATENATE(TableMinMax)

LOAD

min(NumberB) as tMinNum,

max(NumberB) as tMaxNum,

Resident NumberTable;

Wed, 08 Apr 2015 17:39:49 GMT

Yes, that's exactly what I'm trying to do. Thank you!