How to create report by row instead of by column ?

[paulyeo11]

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

[tamilarasu]

Hi Yeo Poh Sai,

Have a look at the attached file.

[paulyeo11]

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

[tamilarasu]

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.

[jerryyang756]

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

then drag colums to row level

Put a space in Window Title in chart properties

[paulyeo11]

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

[jerryyang756 · Accepted solution]

yes in Qliksense it is possible

[paulyeo11]

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

[tamilarasu]

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]

Hi Pritam

Thank you very much for your sharing.

Paul Yeo