topic Re: Displaying value in serial in QlikView

Displaying value in serial

Wed, 25 Nov 2020 16:16:04 GMT

Hi I m new to Qlikview, when i watch the below video run time at 2:45, i could see serial of value as 'Jan, Feb,....Dec'. How can i design which box i have to choose.

Qlikview Introduction - YouTube

Re: Displaying value in serial

swuehl — Sun, 08 May 2016 09:49:40 GMT

These month values are often derived from a date field, using a master calendar:

The Master Calendar

If you are new to QlikView, I would suggest not watching youtube videos that are from 2009. Some few things changed, so I would suggest to go through the free material, webinars and trainings on

New to QlikView

Re: Displaying value in serial

Sun, 08 May 2016 10:55:39 GMT

My requirement is to display the sequence numbers in serial. one more video

How to Build, Enhance and Publish a QlikView App - YouTube

2:06 - time - you can see 1 2 3 4 etc.,

is this derived from any box or through script?

Re: Displaying value in serial

swuehl — Sun, 08 May 2016 15:47:57 GMT

Are you refering to the month numbers 1 to 12 (I assume its showing month number)?

I would suggest that you create a month field in the script (see the link "the master calendar" in my previous post) and then format this month field either in the script or list box as number.

You can also create list boxes that show a month number from a date field using a field expression like

=Num(Month(DateField))

[and assuming that DateField has been interpreted as date, showing a numeric representation]

Again, I would suggest that you are going through some basic free tutorials available in the New to QlikView place.