topic Re: Literal Month Number in QlikView

Literal Month Number

Wed, 26 Oct 2016 08:58:39 GMT

Hi Guys

Please could you assist me with the following:

I have loaded a staffs start date and made end date to be September 2016.

What i would like is for the literal number count to be applied based on the staffs start date month.

For example:

Staff A , started in December 2015 and end date is September 2016.

I would like to display the counter as an expression as Start Month being 1 , second month being 2 and so on:

Date Month Counter

Dec-15	1
Jan-16	2
Feb-16	3
Mar-16	4
Apr-16	5
May-16	6
Jun-16	7
Jul-16	8
Aug-16	9
Sep-16	10

Thanks Guys!

Re: Literal Month Number

sunny_talwar — Wed, 26 Oct 2016 15:50:27 GMT

This you want from the script or directly in your front end chart? I think doing it in the script might be an easier option. Chart expression can get messy

Re: Literal Month Number

marcus_sommer — Wed, 26 Oct 2016 15:50:42 GMT

Most common is to match the start- and end-dates with a calendar per IntervalMatch.

- Marcus

Re: Literal Month Number

sunny_talwar — Wed, 26 Oct 2016 15:51:23 GMT

This blog by HIC have an example of how to this in the script:

Loops in the Script

Re: Literal Month Number

maxgro — Wed, 26 Oct 2016 16:06:46 GMT

(year([Date#(DateMonth, 'MMM-YY')])*12 + Floor(Month([Date#(DateMonth, 'MMM-YY')])) )

(year(min(TOTAL [Date#(DateMonth, 'MMM-YY')]))*12 + Floor(month(min(TOTAL [Date#(DateMonth, 'MMM-YY')]))) )

Re: Literal Month Number

Wed, 26 Oct 2016 16:33:00 GMT

Thanks Gents appreciate it, tried all your methods and it worked.

Appreciate it.

Re: Literal Month Number

maxgro — Wed, 26 Oct 2016 16:45:22 GMT

Qlik Community Tip: Marking Replies as Correct or Helpful