topic Re: Group By issue in QlikView

Group By issue

bharatkishore — Wed, 20 Dec 2017 08:34:43 GMT

Hi All,

I have the following table.

NR:

LOAD Country as Country_NR,

Modality as Modality_NR,

Entitlement,

Date(Makedate((LEFT(Period,4)),(Right(Period,2)),01),'MM/DD/YYYY') AS Period_NR,

Date(Makedate(LEFT(Period,4)),'YYYY') as Year_NR,

Date(Makedate((LEFT(Period,4)),(Right(Period,2)),01),'MMM') as Month_NR,

Year,

[% NORMIB],

Consumption

FROM

[..\QVD\NR.qvd]

(qvd);

Now in the second table when i load:

SC:

LOAD Month_NR,

Year_NR,

Entitlement,

Country_NR,

Modality_NR,

'1' as KPIScope,

sum(Consumption) as Numerator,

sum([% NORMIB]) as Denominator

Resident NR

Group By Month_NR,

Year_NR,

Entitlement

;

I am getting error as invalid expression.

Can you please help me where i am doing wrong.

Thanks,

Bharat

Re: Group By issue

Gysbert_Wassenaar — Wed, 20 Dec 2017 08:45:16 GMT

You need to add ALL the fields that are NOT aggregated to the Group By clause. In your case that means Country_NR and Modality_NR.

LOAD

Month_NR,

Year_NR,

Entitlement,

Country_NR,

Modality_NR,

'1' as KPIScope,

sum(Consumption) as Numerator,

sum([% NORMIB]) as Denominator

Resident

Group By

Month_NR,

Year_NR,

Entitlement,

Country_NR,

Modality_NR

;

Re: Group By issue

bharatkishore — Wed, 20 Dec 2017 08:54:07 GMT

Thanks a lot... Sorry i missed........

Re: Group By issue

Gysbert_Wassenaar — Wed, 20 Dec 2017 09:03:12 GMT

No problem. It's a mistake most of us make at least once. I certainly have several times.