Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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.

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.excel.PNGexcel2.PNG

5 Replies

Re: 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?

Not applicable

Re: 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.

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

Not applicable

Re: 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.

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 columnquarter.PNGthis is the goal of spliting

Not applicable

Re: 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.

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.

Not applicable

Re: 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.

quarter.PNGTHIS IS THE VIEW WHICH I AM EXPECTING

Community Browser