topic Re: Horizontal to vertical in QlikView

Horizontal to vertical

Tue, 24 May 2016 18:51:30 GMT

Hi All,

I have a created a straight table that looks like an image below

However,

I need it to look like something like this one

How can it be done?

Re: Horizontal to vertical

trdandamudi — Tue, 24 May 2016 18:53:09 GMT

Use Pivot chart and you will get the above mentioned chart.

Re: Horizontal to vertical

Tue, 24 May 2016 19:05:16 GMT

I did, i still have the same representation. Tried to compare settings in your version and mine, could not find differences. Could you advise what setting have changed to make it vertical?

Thank you-

Re: Horizontal to vertical

maxgro — Tue, 24 May 2016 19:23:36 GMT

Re: Horizontal to vertical

trdandamudi — Tue, 24 May 2016 19:38:41 GMT

You have to hold the "left mouse button" and then drag the 'Grouped_Status" field horizontally to the top row. (While dragging you will see a blue arrow...)

Re: Horizontal to vertical

Tue, 24 May 2016 19:45:51 GMT

Thank you!

Could you tell me how did you draw a bold line? I created a third expression, figured on the background color, but not sure how to do the line?

Thank you-

Re: Horizontal to vertical

Tue, 24 May 2016 19:48:23 GMT

Re: Horizontal to vertical

Wed, 25 May 2016 14:53:43 GMT

Hi maxgro,

I still cannot figure out how to extend or delete the bold line, could you help?

Thank you-

Re: Horizontal to vertical

trdandamudi — Wed, 25 May 2016 18:05:01 GMT

Nina,

To extend the line to "In Planning" column do as below:

1) Make a right click on 0

2) You should see the below menu.

3) click on Custom Format Cell

4) You will see the below screen:

5) Now select the line you want from "Border before cell" drop down box.

Hope this helps....

Re: Horizontal to vertical

Wed, 25 May 2016 18:43:08 GMT

Awesome! Thank you!

Re: Horizontal to vertical

Wed, 25 May 2016 21:34:04 GMT

HI,

I have tried it one and it worked. However, this menu does not always pop up.

Re: Horizontal to vertical

trdandamudi — Wed, 25 May 2016 22:00:37 GMT

Please make sure you have a check mark against "Always Show Design Menu Items" in user preferences under "Design" tab. see the screen shot below:

Re: Horizontal to vertical

Wed, 25 May 2016 22:12:29 GMT

Tahnk you very much!

Re: Horizontal to vertical

trdandamudi — Wed, 25 May 2016 22:28:51 GMT

You are welcome... Glad able to help...

Re: Horizontal to vertical

Saravanan_Desingh — Thu, 26 May 2016 20:14:21 GMT

If you want to combine the rows into columns, you can use Generic-Load

Data:
LOAD * INLINE [
    Grouped Status, Count
    Draft Report Delivered, 7
    In Progress, 9
    In Planning, 0
];
GenericLabel:
Generic Load  1,*
  Resident Data;
CombinedGenericTable:
Load 1 Resident Data;
FOR i = NoOfTables()-1 to 0 STEP -1
  LET vTable=TableName($(i));
  IF WildMatch('$(vTable)', 'Data.*') THEN
  LEFT JOIN ([CombinedGenericTable]) LOAD * RESIDENT [$(vTable)];
  DROP TABLE [$(vTable)];
  ENDIF
NEXT i 
Drop Table Data;