topic Conditional Dimensions in QlikView in QlikView

Conditional Dimensions in QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Kushal_Chawda — Sat, 12 Mar 2016 09:49:48 GMT

You can do something like below

Click on + symbol of Expression of Attendance & put below expression

its_anandrjs — Sat, 12 Mar 2016 09:50:44 GMT

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