Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chronological Order

I have two fields, one is called Departure Month and the other is Departure Year

Departure Month is listed as a number so January = 1

Departure year is also number so 2017-2017

I want to combine the two into a single dimension so that my dimension is in chronological order.

3 Replies
swuehl
MVP
MVP

Maybe use something in script or chart dimension like

Monthname(Makedate([Departure Year],[Departure Month]))

Anonymous
Not applicable
Author

In the data load editor you can say

Load

      Departure Year & '-' & Departure Month as Fieldname

the result should be Month-Year

eliran
Creator III
Creator III

Hi,

I prefer a different approach, I usually create a date field, makedate(departure year, departure month, 1),and then play with formatting.

But it really depends on the use case, once you got a date, it's easier to calculate gaps between two periods, use set analysis, etc.

On the other hand, sometimes you need / want to keep it simple.

Hope it helps,

Eliran.