Discussion Board for collaboration on QlikView Layout & Visualizations.
I hope someone can help me please. I actually think this should be quite easy, but i cannot find anything on it.
I have a chart (that will eventually become a pivot table) that has the calculations i require. However, i need to devide my value with the total instances of the same on the chart.
So in this example, i need Plan z1 to show 2, and the rest 1. I can then use this number to devide as needed.
If anyone can please guide me in the right direction. Thanx
Go to Solution.
Have a look at the attachment.
This should help you:
count(total <Plan> Plan)
Try this expression.
Thanx for the feedback. Both work on the Chart, but loses the sum if on a pivot table and not fully expanded.
Any tips on that plz?
please find attached.
Thanx for the feedback, but that is not what i am looking for.
What if there were 3 or more instances? and also it should change according to selections.
That is VERY close to what i am looking for!!
The last issue now is that when i do put it in my Pivot table, it doesn't add the values correctly on my partial sums.
Give an example from your sample data, which sum is not matching? what it is showing and what it should be?
Please see attached