topic Re: Error in Expression while using FirstValue in QlikView

Error in Expression while using FirstValue

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to group my data, but I get "error in expression". This is what i'm writing:

any idea?

LOAD Temporada,

Semana,

Ejec.Comercial,

DetalleWeek,

[Estado Week],

NegocioWeek,

[N° Embarque],

[Est. Embarque (3D)],

[Est. Embarque (ERP)],

[Est. Doc. Embarque (ERP)],

FirstValue([Pallets Week]) as PalletWeek

FROM (qvd)

GROUP BY DetalleWeek,NegocioWeek;

Re: Error in Expression while using FirstValue

sunny_talwar — Tue, 30 May 2017 19:48:20 GMT

You have multiple non-aggregated fields in your load statement.... you will either need to add all of them to your group by or you need to remove them from your load statement. Essentially, based on your aggregation requirement, you need to have all your non-aggregating fields in your group by clause.

Re: Error in Expression while using FirstValue

Oleg_Troyansky — Tue, 30 May 2017 19:51:24 GMT

The GROUP BY load has very strict rules - you can only list fields that you are aggregating by, and aggregated values. In your example, you have 10 fields in the LOAD list, but only 2 fields in the GROUP BY list - that's not allowed. You can have either 2 fields in both lists, or 10 fields in both lists - in addition to your aggregations. FistValue() actually looks good, there shouldn't be any issues there.

cheers,

Oleg Troyansky

Upgrade Your Qlik Skills at the Masters Summit for Qlik - coming to Boston, MA this October!