Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month Trending Graph

Hello all

I have a month trending graph where it is showing the number of employees that joined th ecompany in which month.

I have worked out the logic for the graph and i am getting the correct figures but the graph is not sorting by month i.e. Jan, Feb, March ...

... it is random it seems.

How would i be able to sort this ?

Apologies if this is something that is easy to do, i am still very new at QlikView.

Regards

3 Replies
senpradip007
Specialist III
Specialist III

PFA.

senarath
Creator III
Creator III

Hi,

If you are using a calender year, you could follow the reply from Pradip Sen. But if your calender is different such as a fiscal year, you have to sort according to month number which you have to pre define at load script.

thanx

Senarath

Not applicable
Author

Hi,

If you have a table for employees and the date they joined, you could just use something like this as dimension:

MonthName(employeeJoinDate)

And as expression:

sum(employee)

and everything will sort correctly. You do not even need to do anything in the script, you just need a valid date field in your table.

Best regards!

Moritz