I have excel file with column QTR which contains all quarters but when i am loading into the qvw, I want that to be in each quarter in different column.

[#1]

I have excel file with column QTR which contains all quarters but when i am loading into the qvw, I want that to be in each quarter in different column.

[MK_QSL]

Can you provide any sample file or little more explanation for your question?

[#3]

Do you mean you want this to appear in a pivot chart?

[#4]

THIS IS A EXCEL FILE, WHICH I NEED TO TRANSFORM AND CREATE A TRANSFORM.QVW.

THE FORMAT OF QTR column should be changed to quarter wise i.e; split the QTR columnthis is the goal of spliting

[#5]

In Qlivkiew select the chart type of Pivot Table (top right option in General tab).

Set Quarter to a dimension, expand your groups and click&drag your Quarter field to the top (causing a blue line to appear horizontally).  All expressions should now be replicated for each Quarter column.

[#6]

THIS IS THE VIEW WHICH I AM EXPECTING