Discussion board where members can get started with Qlik Sense.
I'm trying to create a pivot table that shows the percentage of a count of values. The rows should equal 100% (for each date).
At the moment I've used this:
Count(Attainment) / count(total <[Pupil report data.Subject]> Attainment)
This isn't working as it is returning a total of 100% for every value in the pivot table, not by row or subject.
Any ideas would be much appreciated!
What all dimensions do you have in this chart?
For the rows, the dimensions are:
And the column dimension is 'Attainment'
Does have anyone have any nuggets of info they could offer?
Can you share some sample table?
Count(Attainment) / count(total <[Report Cycle.autoCalendar.YearMonth]> Attainment)
Sum(Attainment) / Sum(Total Attainment)
it should work for you. Don't forget to format the number as %
Unfortunately this doesn't work... The result is the same as in the example I showed.
Unfortunately, this also doesn't work. I have the same result as above.
Yes, I'll remove names etc. from the data and upload it ASAP.