Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

achakilam1022
Contributor II

Aggregation on Calculated Dimension

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!

6 Replies
devarasu07
Honored Contributor II

Re: Aggregation on Calculated Dimension

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

Can you replace it to first place

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


Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: Aggregation on Calculated Dimension

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

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

Or

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

or if this is row wise, may be this

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

Highlighted
achakilam1022
Contributor II

Re: Aggregation on Calculated Dimension

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

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

achakilam1022
Contributor II

Re: Aggregation on Calculated Dimension

I've made some changes in script load editor

I appreciate your help