topic Re: Aggregation on Calculated Dimension in QlikView

Aggregation on Calculated Dimension

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

Hi all,

I've a calculated dimension 'FinalSegment' and I need to create a Cost measure which uses aggregation on FinalSegment. I tried the following and it didn't work.

I've created variable vFinalSegment : if(len(trim(Segment))=0,Segment_2,Segment)

Cost =

sum(aggr(Cost, ID,Buyer,$(vFinalSegment) ))

But, this measure returns 0.

May I know how to do this?

Thanks!

Re: Aggregation on Calculated Dimension

devarasu07 — Thu, 14 Dec 2017 22:18:27 GMT

hi,

try like this

Method 1:

create calculated dimension

aggr(sum( {$<Segment={"=len(trim(Segment))<=0"}>}cost),Segment_2,Segment)

method 2:

dimension:

Segment

Segment_2

Measure:

sum( {$<Segment={"=len(trim(Segment))<=0"}>}cost)

if still not working, try to share mock data with expected output in excel format

Thanks,

Deva

Re: Aggregation on Calculated Dimension

Anil_Babu_Samineni — Fri, 15 Dec 2017 02:00:51 GMT

Can you replace it to first place

Sum(aggr($(vFinalSegment),Cost, ID,Buyer))

Re: Aggregation on Calculated Dimension

sunny_talwar — Fri, 15 Dec 2017 10:52:15 GMT

Are you evaluating your variable rowwise or chartwise? For chart wise, may be try one of the two:

Sum(Aggr(Cost, ID, Buyer, $(=vFinalSegment)))

Sum(Aggr(Cost, ID, Buyer, $(=$(vFinalSegment))))

or if this is row wise, may be this

Sum(Aggr(Cost, ID, Buyer, Segment_2, Segment))

Re: Aggregation on Calculated Dimension

achakilam1022 — Fri, 15 Dec 2017 14:59:58 GMT

Hi Sunny,

I'm, doing it chart wise; I've tried the expressions you've suggested but they are returning 0

Any clue what could be going wrong?

I appreciate your help. Thanks!

Re: Aggregation on Calculated Dimension

sunny_talwar — Mon, 18 Dec 2017 23:43:00 GMT

Would you be able to share a sample to check this out?

Re: Aggregation on Calculated Dimension

achakilam1022 — Thu, 21 Dec 2017 18:35:56 GMT

I've made some changes in script load editor

I appreciate your help