topic Pivot a Line Graph in QlikView

Pivot a Line Graph

Wed, 09 Sep 2015 10:55:40 GMT

Hi,

Trying to create a Line chart that is pivoted to look like the below graph. How is this done in Qlikview?

Desired output:

Data source:

	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6
Store1	3	5	8	5	7	8
Store2	4	6	6	6	5	3
Store3	3	7	6	7	4	4
Store4	2	2	9	8	1	6
Store5	9	3	9	3	1	7

Thanks

MVW

Re: Pivot a Line Graph

lironbaram — Wed, 09 Sep 2015 11:52:36 GMT

in qlikview we'll use crosstable

the will transform your table to

table with those columns:

Store,Month,Data

store1,month1,2

store1,month2,4

and then create simple line chart with two dimensions

attach is a demo model

Re: Pivot a Line Graph

Wed, 09 Sep 2015 13:32:41 GMT

Hi,

Thanks for that, but I'm not sure it takes me forward. Unless I am misunderstanding, your solution resolves the issue by restructering the data during the loading process. I was really looking to resolve the issue in the Graph interface. Is this possible? I can't amend my load process like yours:

CrossTable(Month,Data,1)
LOAD * INLINE [

Mine is:

LOAD A,
     B,
     C,
     D,
     E,
     F,
etc

I think mine needs to stay in this format as there are many different data items in my spreadsheet (columns A-FF in Excel). I had simplified my data structure for the purposes of the messageboard.

MVW