Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

IAMDV
Honored Contributor II

*** Need help with Aggr() Expression ***

Dear All,

I am stuck with an expression which works fine when I filter the data and it gives incorrect numbers when I dont filter the data. Here is the expression...

Dimension :

ParentID

Expression :

SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId))


This works fine, when I filter on the Field ParentID (Which is my only dimension). However, if I dont filter on the ParentID it gives incorrect numbers. I am not sure where is the problem. Unfortunately I cant load the QV document because it contains sensitive information. Can someone please help...?

Thanks a ton in advance.

Cheers - DV

1 Solution

Accepted Solutions
danielrozental
Honored Contributor II

*** Need help with Aggr() Expression ***

Try

SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId, ParentId))


2 Replies
danielrozental
Honored Contributor II

*** Need help with Aggr() Expression ***

Try

SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId, ParentId))


IAMDV
Honored Contributor II

Re: *** Need help with Aggr() Expression ***

Daniel – Thanks so much for quick response. This was a silly question... I went back last night and referred the documentation again and gotit working.

Cheers - DV

Community Browser