I need a help with a bar graph. I want to plot a graph with variable "subjects" in dimension and student's marks as a measure. And I want to show that if I select a particular student, I get a bar graph showing his marks in all the subjects. The below image depicts what I want with students name in filter.
There is no group option as such in QlikSense. But you can achieve this using an extension and pick() function.
Create an extension(Toggle buttons or a single button based on your requirement) which toggles through the numbers 1 to 4 and this extension should update a variable (vPick) with the number.(Assuming that there are only 4 dimension to go around)
now use this as your dimension in a bar chart.
If this is a must have requirement, let me know and I will help you build an extension for you.
You do not have an option to define a group in QlikSense. But there are alternatives to achieve the same using extension objects. You need to develop one with the functionality I mentioned. The main purpose of this extension would be to update a variable with number 1 to n based on the number of dimension required in the group.
This updated variable can be used in a calculated dimension like this:
Can you please explain it using the sample data I attached? I get the subjects in dimension but when I take marks as a measure, I need to add an aggregation. Using sum aggregate, I get the sum of marks obtained by all the students in that particular subject. Whereas what I want is that if I select a particular student,say B, then I want a graph of actual marks obtained by that student 'B' in different different subjects.
So what you need here is a drill down dimension and not a group.
So As you wanted: When you select a student it should drill down to his respective subjects. Right?
If thats the case, Create a master dimension in QlikSense which is a drill down.
Check the QVF which I have attached.