Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
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
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