topic Help me on aggr in QlikView

Help me on aggr

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

!Hi,

My requirement is in the UI and backend

I have used in the front end Sum(distinct Actual) and also aggr(Sum(distinct Actual),[Profit Center])

But am not getting what exactly am looking for

PFB for your reference.

Any help will be appriciated.

gowtham_patnaik — Fri, 02 Jun 2017 06:32:06 GMT

Hi,

Try this expression:

Sum(aggr(Sum(distinct Actual),[Month-Yr],PC,[Profit Center],[Acct Name]))

antoniotiman — Fri, 02 Jun 2017 06:48:01 GMT

Hi,

May be

If(Dimensionality() > 0,Sum(DISTINCT Actual),Sum(Aggr(Sum(DISTINCT Actual),[Profit Center])))

Regards,

Antonio

satishqlik — Fri, 02 Jun 2017 07:30:09 GMT

What about in the backend???

I want to see in the data model.

antoniotiman — Fri, 02 Jun 2017 07:58:32 GMT

May be

Remove Join in second LOAD (t2 table) and expression :

Sum(Actual)