Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a requirement to create a chart as shown in the below image. My source tables are Table 1 and Table 2.
I have two measures Marks and Attendance.
Marks need Student ID and Subject as dimension whereas Attendance needs Student ID alone as dimension.
Is it possible to achieve in QlikView. If not can you please suggest some alternate way which conveys the same information.
Thanks
Koushik
You can do something like below
Click on + symbol of Expression of Attendance & put below expression
Hi,
Yes you can achieve this in Qlikview see the example.
//Mapping Table for attendance data
Att:
Mapping LOAD * Inline
[
StudentID,Attendance
1,80
2,65
];
LOAD *,ApplyMap('Att',StudentID) as Attendance;
Load * Inline
[
StudentID,Subject,Marks
1,Math,80
1,Sci,70
2,Math,90
2,Sci,60
];
In any Pivot table you can write.
Dim:- StudentID,Subject, Attendance
Expre:- Sum(Marks)
Regards,
Anand