If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I'm hoping someone can help. I've got a chart looking at grades achieved for a particular module. I've hit a bit of a snag however, I'd like each chart to display all the potential grades across the horizontal axis, including those not recorded in the dataset. e.g a module might have any number of the following grades - A+, B+, C, D+, D, F.
What I'd like to do is include the full list of grades which could have been achieved so the axis would read A+, A, B+, B, C+, C, D+, D, MF, F.
I tried adding in an inline table (see below) and turned on 'show null values' but they don't appear.
LOAD * inline [
Does anyone have any ideas whether this is possible?
Have you tried (in your load script) to concatenate your Inline table above with your source data grades table to create a new table which contains all the grade dimension values that you want to show?
If you need certain grades not to change, consider using set analysis.
In fact you can insert set analysis functions using the function editor.
In this example I've created a Master items alternate state with 2020 as a selection.
Then 'insert' that alternate state to the chart I want to apply it to. (You do not need to type the code. The insert action creates it for you. Here Inserted the '2020' alternate state. You can also insert a bookmark or 'selections' made before opening the function editor.
Not sure if that will meet your requirement but it's something you can try....
Thanks for the suggestion. I understand where you're coming from but I think I haven't described my issues very clearly so I'll try again.
The POSSIBLE grades range from A+ to F. Our data contains grades ACHIEVED by students. The students grades may not include certain grades e.g. results may include 1 x A+, 2 x A, 3 x B-, 4 x C. What we'd like to do is put these results on a chart but include the grades which weren't achieved on the axis (e.g. A+, A, A-, B+, B, B- etc...).
I'm not sure whether this is even possible! Hope this makes sense though.
simply add dummy data rows to your data set
Load * inline [
//ADD LIST OF ALL GRADES TO THE FACT TABLE
Load * Inline [
This way all grades will show up in your charts simply make sure to check
Include Zero Values under Data Handling>>Add-Ons