topic Re: Month function in QlikView

Month function

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have one filed called "monthyear" . in my pivot table monthyear is the dimension. there it shows 42370,42430..like that instead jan ,fed,...dec

How i can change the those numerical values into text?

if i writhe month(42370) then it will give the jan.. but here i want dynamically?

pl help me on this

Thanks in advance

surendraj — Fri, 24 Feb 2017 06:55:45 GMT

Try with

month(Date(42370)) -->It will give you jan.

In script level..

month(Date(Filed name)) as Month

So here

month(Date(monthyear)) as Month.

tresB — Fri, 24 Feb 2017 06:59:29 GMT

May be just -

Month(monthyear) ?

dsharmaqv — Fri, 24 Feb 2017 07:06:19 GMT

Simply use

=Date(monthyear)

or if you display month then

=Month(monthyear)

i did not understood what do you mean by dynamically?

muthukumar77 — Fri, 24 Feb 2017 12:18:39 GMT

Hi,

Use

=Month(42370)

it will be return "Jan"