topic Re: Sales in Percentage in QlikView

Sales in Percentage

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

Please Help Me,

My Requirement is to show top 20% sales not top 20 sales .

the user will give input value in input box like he want to see top 10% or 20% ie

we are not suppose to use dimension limites only by using input box

Re: Sales in Percentage

sinanozdemir — Mon, 07 Dec 2015 18:15:17 GMT

Quick question: When you say top 20%, would that include only 0% to 20% or only the items within 20% to 29%? I ask this because in your example every item has a fraction.

Thanks

Re: Sales in Percentage

sinanozdemir — Mon, 07 Dec 2015 18:36:49 GMT

Let me make my question clear.

When you say top 20% which of the records you are expected to show?

Re: Sales in Percentage

maxgro — Mon, 07 Dec 2015 19:06:25 GMT

Try with a button and a Pareto select

Replace percentage with the variable of the input box

Re: Sales in Percentage

Tue, 08 Dec 2015 01:19:02 GMT

Thanku for u response Ozdemir,

i want to see like contribution fo a particular country in my profit . in this case i want to see only contribution percentage

abovei posted is sample data atleast show me top 5% countries contributing in profit.

eg:

in one country there are 3000 stores then top 10 sales will give top 10 values but top 10% values count might be differ

Re: Sales in Percentage

maxgro — Tue, 08 Dec 2015 07:43:31 GMT

PFA

Re: Sales in Percentage

tyagishaila — Tue, 08 Dec 2015 07:54:53 GMT

Try it;

Use calculated Dimension in place of custCountry

Add Calculated Dimension

=aggr(if(rank( sum(unitsSold)/Sum(Total unitsSold))>= 0.20, custCountry), custCountry)

in place of 0.20 you can use variable..

and this variable value can be entered by user in Inputbox.

Let me know is this working or not?