Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I want to crate a line chart where I have the customers on the left axis, the netWeight on the rigt and the periods (months) on the bottom
Can anybody give me a suggestion please
Thanks
//Lennart S
Customer | YearMonth | Sum(NetWeight) |
0106 Dpn AB | 201404 | 50,05 |
1935 Skånetryck AB | 201401 | 2119,4 |
1935 Skånetryck AB | 201402 | 1434,1 |
1935 Skånetryck AB | 201403 | 1497,6 |
1935 Skånetryck AB | 201404 | 2995,2 |
1935 Skånetryck AB | 201405 | 2246,4 |
1935 Skånetryck AB | 201406 | 2182,9 |
3156 M Kopia I Stockholm AB | 201404 | 29,44 |
3269 Exaktaprinting AB | 201401 | 1200,5 |
3269 Exaktaprinting AB | 201402 | 1030,4 |
3269 Exaktaprinting AB | 201403 | 1133,44 |
6340 Tryckfolket I Malmö AB | 201406 | 2471,04 |
7591 Exellent / O I Ingmarsson, AB | 201401 | 37,5 |
9813 Printografen Grafisk | 201401 | 48,96 |
9813 Printografen Grafisk | 201403 | 202,4 |
9813 Printografen Grafisk | 201404 | 2607,08 |
9813 Printografen Grafisk | 201406 | 198,72 |
10035 EKLUNDENS GRAFISKA AKTIEBOLAG | 201404 | 21,6 |
10038 Star-tryck AB | 201402 | 2685,15 |
10038 Star-tryck AB | 201405 | 650,65 |
- YearMonth would be your dimension.
- Customer and NetWeight would be your expressions.
- You can assign the second expression to the right axis, by going to the 'axis' tab, and the 'position' section.
Hi
Thanks for a very fast answer, I will work on your suggestion
//Lennart S
Från: Charlotte Gilbert
Skickat: den 31 juli 2014 10:17
Till: Lennart Stenius
Ämne: Re: - How do I create a chart with customers on the left, sales values on the right and months at the bottom?
Qlik Community<http://community.qlik.com/>
How do I create a chart with customers on the left, sales values on the right and months at the bottom?
reply from Charlotte Gilbert<http://community.qlik.com/people/c_gilbert?et=watches.email.thread> in Layout & Visualizations - View the full discussion<http://community.qlik.com/message/579685?et=watches.email.thread#579685>
can u plz attach a sample?