topic Re: Resident in QlikView

Resident

Mon, 29 Oct 2012 13:28:16 GMT

Can we use group by function for resident table as below. No giving any error. But i am not sure about it. Please suggest whether it is right way or not.

For Exp:

Load *

from etc.xls

load *,

min(Field_name) as minfield

resident A group by Field_names;

drop table A;

Re: Resident

Mon, 29 Oct 2012 13:34:22 GMT

of course you can, but be careful with the stars and grouping fields.

Your example a little bit modified without errors.

Load

ID,

Value

Inline

[ID, Value

1, 3

1, 5

1, 7

2, 4

2, 6

2, 8];

LOAD

ID,

Min(Value) as MinValue

Resident

Group by ID;

drop table A;

Re: Resident

CELAMBARASAN — Mon, 29 Oct 2012 13:44:58 GMT

You should not use * to selection while using group by.

You can select fields by using Aggregation functions and the fields used in group by clause.

Example:

Load

ID,

PName,

Price,

Unit

From Datasource;

Load

ID,

PName,

Max(Price) AS MPrice,

Max(Unit) AS MUnit

Resident A

Group By ID, PName;

I can use the ID and PName fields directly but not the Price and Unit. To use this fields i should apply some group by or aggregation functions.