Discussion board where members can get started with QlikView.
I built a straight table , where I've shown the first 3 items on a total of 10 items.
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?
Please share the app
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?
Your straight table is not correct. Can you share the data?
Share the sample App
Thanks & regards,
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?