topic Re: Total Percentages in QlikView

Total Percentages

Mon, 05 Jan 2015 11:47:47 GMT

Hi all,

From the example seen below, instead of having 100% for the Sales %, how can I get the sum of the sales %'s? i.e. Instead of 100%, I will have 99.9%?

Currently in my dimensions, I have something like this:

=aggr(if(rank(Sum({< TransactionType = {'PLSF'}, MN_Num = {$(vReportingDate)} >} CONTRACTED_Euro /1000000 ) * vDspCurrXrate ) <= 10, Only({< TransactionType = {'PLSF'} >} [Client Group])), [Client Group])

Re: Total Percentages

marcus_malinow — Mon, 05 Jan 2015 11:59:30 GMT

You could try changing the Total Mode of your expression from Expression Total to Sum of Rows.

Re: Total Percentages

Mon, 05 Jan 2015 12:00:17 GMT

Hi Marcus,

Its already set to sum of rows. But it has not made any differences

Re: Total Percentages

marcus_malinow — Mon, 05 Jan 2015 12:06:56 GMT

Ok then, it's likely that you have some values being rounded down.

For example

1.53

Sum = 4.59

In this example if you show it to 1dp, you'll see

1.5

Sum = 4.6

You could try using round in your expression

round ([Your Existing Expression], 0.1)

And retain Sum of Rows

Re: Total Percentages

Mon, 05 Jan 2015 12:10:19 GMT

I understand what you just said, however, I dont want to round the values, I want to use them as they are

e.g. 38.2 + 29.8 + 17.6 etc.

Is this not possible?

Re: Total Percentages

marcus_malinow — Mon, 05 Jan 2015 12:20:59 GMT

If you use 0.1 as the second parameter for round, youll still see everything to 1dp

Re: Total Percentages

rubenmarin — Mon, 05 Jan 2015 12:25:39 GMT

Hi Sabah, the unrounded results (from the rounded sales data you posted) are:

16,3	38,2629108
12,7	29,8122066
7,5	17,6056338
1,4	3,28638498
1,1	2,58215962
0,8	1,87793427
0,7	1,64319249
0,7	1,64319249
0,7	1,64319249
0,7	1,64319249

and it sums 100, if you want it to sum 99,9 you need to round them to the first decimal as Marcus said.

Re: Total Percentages

Mon, 05 Jan 2015 12:27:31 GMT

Thank you all for your help 🙂

Re: Total Percentages

Anonymous — Mon, 05 Jan 2015 12:33:51 GMT

Hi Try below logic and setting .

See the example. You will get 99.9 % for your expression.