Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a specific requirement for a line chart and i dont really know how to realize it.
I have data like the following - ordner numbers with a month dimension and a sum of hours.
My goal is to compare the sum of hours for the appropriate months between several order numbers.
lets say i have the following data:
Order No X
Month, Sum hours
2021 02, 10
2021 03, 20
2021 04, 15
2021 05, 30
Order No Y
Month, Sum hours
2021 08, 20
2021 09, 30
2021 10, 45
2021 11, 39
I could put that data on a line chart now with two lines for the two order numbers.
The problem is, that the hours belong to different months and therefore it is difficult to really compare the values.
For that i would need to convert the months to an ordered number list.
I dont really care which month it is.
At the end per order number i need the following new data:
Order No X
Month, Sum hours, MonthNrOrdered
2021 02, 10, 1
2021 03, 20, 2
2021 04, 15, 3
2021 05, 30, 4
Order No Y
Month, Sum hours
2021 08, 20, 1
2021 09, 30, 2
2021 10, 45, 3
2021 11, 39, 4
That way i could lay the data on a line chart and they would appear on the same x-values which makes it easier to compare.
Can somebody give me a hint on how to achieve this?
Thanks a lot!
When you load the data, assign a MonthOrder field using AutoNumber() like this:
AutoNumber(Month, OrderNo) as MonthOrder
Make sure your input data is sorted by Month.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
When you load the data, assign a MonthOrder field using AutoNumber() like this:
AutoNumber(Month, OrderNo) as MonthOrder
Make sure your input data is sorted by Month.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com