Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Re: Want to calculate market share based on the partial sums

The expression should work...

Could you please provide us a sample qvw?

Thank you.

Marc.

Highlighted
Specialist III
Specialist III

Re: Want to calculate market share based on the partial sums

I changed it but the same result as above even this time the partial sums changed to 100%

kiran

Highlighted
Specialist III
Specialist III

Re: Want to calculate market share based on the partial sums(second dimension percentages)

Finally got it , when we have calculated dimension we have to use advanced aggregation using aggr().

The following post helped me alot

Quick Development Tips: Qlikview: Aggregation 1: How to calculate percentages at second dimension le...

The expression which I have used for market share is

  Sum({1<Commodity=p(Commodity),QuarterYear={$(vCurrentQuarter)}>}Spend)

  /

  Aggr(NODISTINCT Sum({1<Commodity=p(Commodity),QuarterYear={$(vCurrentQuarter)}>}Spend),Commodity)

Thanks

Kiran Kumar .CH

View solution in original post