Field as row in Table object

[chnarayanrao]

I have below fields to create a table object in Qlikview. ID, Name, Subject,AVGmarks,Sem1,Sem2,Sem3.

I want to display the data as per the attached format. Could you please help ,how I can achieve this. AVGmarks field should be displayed as row to show the avg marks for each semister..

[jobsonkjoseph]

Hi, It is better to go with Pivot Table option.

[chnarayanrao]

Any idea How to do this? I have AVGMarks1, AvgMArks2 etc as fileds. I need to show for ID , for a semister, i need to show AvgMarks.

[vamsee]

can you attach some sample source data

[chnarayanrao]

Hi Vamsee, it's available in my original post. Attaching again.

[vamsee]

Was requesting you for the source data sample, i.e. with the fields 

AVGMarks1.AVGMarks2 etc.

The attachment is the output expected right.

[vamsee]

If that is indeed your source data and I misinterpreted your question then please find the attached qvw

[chnarayanrao]

Hi Vamsee,

Thanks for this, appreciate your help.

I am posting now the source data. In the attached excel ,here has expected result(sheet 1) and source data in sheet 2&3. Could you please help me for this.

[vamsee]

Please find attached.

Solution: CrossTable (Semester, Marks, 3)

[chnarayanrao]

Hi Vamsee,

Thanks for this. Could you please place the script here? I couldn't open the qvw at the moment.