topic Re: Month Trending Graph in QlikView

Month Trending Graph

Thu, 11 Sep 2014 04:09:06 GMT

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

Re: Month Trending Graph

senpradip007 — Thu, 11 Sep 2014 04:36:17 GMT

PFA.

Re: Month Trending Graph

senarath — Thu, 11 Sep 2014 05:12:55 GMT

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

Re: Month Trending Graph

Thu, 11 Sep 2014 06:03:35 GMT

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