Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

need help

i want to get retail and wholesale contribution to another column. In my chart I have retail sale and whole sale in two rows.

as an example, if my retailsale=500 and Wholesale=1000, i want to get the contribution as retail contribution=(500/(500+1000))*100 automaticaly and same as whole sale contribution. how can I do this in a chart expression?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: need help

SUM({<Type = {'retail'}>}Sales)/SUM(TOTAL Sales)

and

SUM({<Type = {'wholesale'}>}Sales)/SUM(TOTAL Sales)

You can try both

with TOTAL and without TOTAL

UPDATE : Don't forget to go to number tab and select show in percentage%

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: need help

SUM({<Type = {'retail'}>}Sales)/SUM(TOTAL Sales)

and

SUM({<Type = {'wholesale'}>}Sales)/SUM(TOTAL Sales)

You can try both

with TOTAL and without TOTAL

UPDATE : Don't forget to go to number tab and select show in percentage%

View solution in original post

Highlighted
Not applicable

Re: need help

thanks