Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Get region contribution for stores

Hi, I looking for a solution to get region sales next to respective store.

In the attachment the table marked with green square has showroom name and sum of Net sales. I need to get the region sales for respective stores which would help me understand % contribution to region.

Region is 1 level up in hierarchy which is present in Showroom attributes table marked in red square.

Please can someone help me resolve this.

Thanks

Sujay

1 Solution

Accepted Solutions
Not applicable

Re: Get region contribution for stores

You are correct... We dont need the {1}

Final code is aggr(sum( Total <Region> [Sd Net]),[Region],[Showroom])

4 Replies
Not applicable

Re: Get region contribution for stores

Found the answer... aggr(sum({1} Total <Region> [Sd Net]),[Region],[Showroom])

kkkumar82
Valued Contributor III

Re: Get region contribution for stores

Hi Sujay,

Do you really require {1} check that once as it won't accept any selections , if it is fine close your ticket by pressing

correct answer in actions so that it may help to some others

agigliotti
Honored Contributor II

Re: Get region contribution for stores

sum(Net)

/

sum( TOTAL <Region> Net )

Not applicable

Re: Get region contribution for stores

You are correct... We dont need the {1}

Final code is aggr(sum( Total <Region> [Sd Net]),[Region],[Showroom])