How to use group by in Qlikview?

[#1]

Hi,

I would use group by like in sql but my code doesn't run.

I understand I must use group by with a resident table but impossible to run my app!!

load ID_DI,  count ([ID_Intervenant]) as [nb techniciens] resident tab  group by ID_OT;

Could help me please?

[Anonymous]

However  last day i tested that it is not  necessary to use all fields.

This you can do in two step.

1. load orignal table.

2. take resident of orignal table and use the field and expression, something like this below

load

ID_OT,

Count( ID_Intervenant ) as nb_technicien

Resident OT Group by ID_OT ;

Actually   Mr XAVIER is using the below code

load ID_DI,  count ([ID_Intervenant]) as [nb techniciens] resident tab  group by ID_OT;

but if instead he use

load

ID_OT,

Count( ID_Intervenant ) as nb_technicien

Resident OT Group by ID_OT ;

it will definetly work.

ANANT

[narender123]

Yes you are right .

Narender

[ParthKoul1]

Hi,

I have another question related to group by -

example- 

Load- 

QOH,

ITEMCOST,

QOH*ITEMCOST AS TOTAL COST,

LISTPRICE,

SUM(QOH*LISTPRICE)

What fields do I group by this on? In group by if I am calling Total Cost it says not found. Do I use formula in the groupby then?