Hi,
I have built a data model of reports; simplyfying:
Every year, multiple-choice tests are given to resources.
Every resource completes one test for each "macro-role" he has assigned and each test consists in a certain number of questions.
Further, for each resource, it is calculated the percentage of wrong answers, mapped into a number (from 1 to 6).
Eventually, in a dimension, I map for each one of those codes an extended name (e.g. 1<->"molto grave", which means severe skill GAP).
I'd like to represent in a line and a bar chart how those GAP levels are cumulately distributed through the years:
each line/bar is a year; each bin value/bar portion is the percentage of resources that had the corresponding GAP for that year.
The current formula is: "=count(COD_GAP_DIPENDENTI) /count(TOTAL[COD_GAP_DIPENDENTI])", where "COD_GAP_DIPENDENTI" is that number between 1 and 6.
The issue is: if I filter only one year, everything is correct: the length of the bar and the sum of the bin's height is 100.
But if I choose more than one year (for instance: 2022 and 2023), it won't show me a comparative vision, because I obtain 100 only if I sum the two bars length and the bins of both lines!
I currently don't know a way to tell Qlik to consider, for each line/bar, only the data associated with that year.
In the attachments: the 'wrong.png' way it works with more than one year selected that I'd wish to turn into the 'right.png' that currently holds only for a single year!
Thank you all 🙂
