Ordered number values for dimension values

schmidtj — Mon, 20 Dec 2021 21:02:46 GMT

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!

Re: Ordered number values for dimension values

rwunderlich — Thu, 08 Apr 2021 15:55:29 GMT

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

topic Re: Ordered number values for dimension values in App Development

Ordered number values for dimension values

Re: Ordered number values for dimension values