Conditional Dimensions in QlikView

[Anonymous]

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

[Kushal_Chawda]

You can do something like below

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

[its_anandrjs]

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