Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sirioblonna
New Contributor

Percentage of first 15 elements

Hi,

I built a straight table , where I've shown the first 3 items on a total of 10 items.

ClientActualPrevious% Act - Pvs
A105100%
B1510
50%
C201533%
Total453075%

When I do the subtotal, the columns Actual and Previous give the right result, but the total percentage (the red value) is wrong!! (the total could be 50%).

Instead of doing the sum of partial values (3 items), it sums the total values (10 items).

I've also set the formula on : expression -> mode of totalization (total expression)

Could anyone help me please?

Thanks!

5 Replies
shiveshsingh
Honored Contributor

Re: Percentage of first 15 elements

Please share the app

Digvijay_Singh
Honored Contributor III

Re: Percentage of first 15 elements

Not sure how are you filtering your total 10-15 items to 3 items? Are you making selections in filter to reduce your straight table to 3 items?

isingh30
Valued Contributor

Re: Percentage of first 15 elements

Your straight table is not correct. Can you share the data?

venkatasreekant
Valued Contributor

Re: Percentage of first 15 elements

Hi,

Share the sample App


Thanks & regards,

Venkata Sreekanth

sirioblonna
New Contributor

Re: Percentage of first 15 elements

3 Items were just an example. I filtered on 15 items.

The question is.....why the total percentage is on the total and not on the subtotal?

Filter.jpg