Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

harjedalskok
New Contributor III

How to show the the percentage

Hi,

Im trying to make a chart that shows the percentage of a salesman qualitykitchen based on total amount of sold kitchen.

When i do this, i get the percentage of quality kitchen the salesman has sold based on all qualitykitchen, not based on how many the specific salesman has sold.

could somebody point me in the right direction.

I have made 3 charts in the sample, to show wich values i would like to take a percentage of.

Thx in advance.

5 Replies
jebamalai
Valued Contributor

Re: How to show the the percentage

Go to Expressions tab and tick "Relative".that will show the % of the sales made by salesman our of total sold

harjedalskok
New Contributor III

Re: How to show the the percentage

That doesent gives me the percentage of quality kitchen that specific salesman sales.

jebamalai
Valued Contributor

Re: How to show the the percentage

what % you are geting?

I can see 11.52% for Andreas.

Is that what you were looking for.

Or message me the manual calculation,we will get that done

adrianbuzer
Contributor II

Re: How to show the the percentage

The problem is that the count of total orders is on dimension Saljare5 and the count of qualitykitchen is on dimension Saljare2.

Count(OrderID5) returns 17173 regardless of which Salesman is selected under Saljare2

harjedalskok
New Contributor III

Re: How to show the the percentage

Good Morning,

Ive let the to orderheading tables share the same salesmans table now. That works and i get the right percentage.

But it it feels like there must be an easier way with set analysis, so i dont need to have double set of everything and making double the selection.

I mean, that i should be able to make an expression that says, divide the selection (kvalkök2) with orderid2 (excluding the selection of (kvalkök2)?

its that possibel, im signed up for the training of seth anaylysis in sept. but i cant wait until then to fix this charts

/André

Community Browser