Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you provide any sample file or little more explanation for your question?
Do you mean you want this to appear in a pivot chart?
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
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.
THIS IS THE VIEW WHICH I AM EXPECTING