Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

How to create report by row instead of by column ?


Hi All


Now i create create report as below :-

SOURCE LY Sales YTD Sales

TDSS 910,000 1,040,000


May i know how to create a report as below :-

LY Sales 910,000

YTD Sales 1,040,000


Paul

1 Solution

Accepted Solutions
pritamb89
Contributor

Re: How to create report by row instead of by column ?

yes in Qliksense it is possible

s1.PNG

10 Replies

Re: How to create report by row instead of by column ?

Hi Yeo Poh Sai,

Have a look at the attached file.

paulyeo11
Valued Contributor II

Re: How to create report by row instead of by column ?

Hi Tamil

Thank you very much , can you share how you do it ? Why it does not display the label ? i am using ver 9

NOT WORD ON 1 COL.png

Re: How to create report by row instead of by column ?

Hi Yeo,

Yeo Poh sai wrote:

can you share how you do it ?

Here are the steps.

1) Change the straight table to pivot table.

2) Remove source field from dimension.

3) Drag and drop the YTD Sales from top to bottom.

4) Remove Wrap header text tick mark from presentation tab.

Yeo Poh sai wrote:

Why it does not display the label ? i am using ver 9

It should work. Could you please check the below attachment and confirm whether you still face the same issue.

Capture.PNG

pritamb89
Contributor

Re: How to create report by row instead of by column ?

Table:

LOAD * Inline [

SOURCE,LYSales,YTDSales

TDSS,910000,1040000

];

Take a pivot table chart and add two expression as LYsales-> Sum(LYSales) and YTDSales->Sum(YTDSales),

Don't need to add any dimension

1.PNG

then drag colums to row level

2.png

Put a space in Window Title in chart properties

3.PNG

paulyeo11
Valued Contributor II

Re: How to create report by row instead of by column ?

Hi Tamil

Now working fine. ( I need to copy and paste then the label appear)

May i know it is possible to create this in QS ?

Paul

pritamb89
Contributor

Re: How to create report by row instead of by column ?

yes in Qliksense it is possible

s1.PNG

paulyeo11
Valued Contributor II

Re: How to create report by row instead of by column ?

Hi Pritam

Thank you very much for your sharing.

it is possible to make YTD Sales at row 1 ?

As my actual application have more then 2 column, it is possible ?

Paul

Re: How to create report by row instead of by column ?

Hi Paul,

Yes, it is possible. I have recently started to work in Qlik Sense (I just checked before answer anything ) so sorry for taking long time to respond.

paulyeo11
Valued Contributor II

Re: How to create report by row instead of by column ?

Hi Pritam

Thank you very much for your sharing.

Paul Yeo

Community Browser