topic Re: date(Floor(MyDate),'MMM') in QlikView

date(Floor(MyDate),'MMM')

AnnaQlik — Sat, 16 Nov 2024 21:10:39 GMT

Hi!

I have a timestamp and have managed to make it into only YYYY-MM-DD by using date-floor-function. It works perfectly!

When only using date-function, without floor, duplicates of the date appear, see the attached picture. Therefore I am using the floor-function aswell.

datInkomDatum,
date(Floor(datInkomDatum)) as datInkomDAG,

date(datInkomDatum) as datInkomTEST,

However, when I use the same method (date-floor-function) to get the months out, it shows duplicates of the months.

date(Floor(datInkomDatum),'MMM') as datInkomMÅN,

How do I get the months out like I did with the dates for datInkomDAG?

Thank you!

Re: date(Floor(MyDate),'MMM')

wandererroch — Tue, 26 Mar 2019 12:00:35 GMT

Easiest way is to wrap the date in monthstart(). This will give you a consistent point of reference. Qlikview likes to hold on to the actual date in the background even when you ask only for the month portion.

Re: date(Floor(MyDate),'MMM')

amrinder — Tue, 26 Mar 2019 12:07:34 GMT

Hi,

When you are using only Date function,May be due to different time available on same date it is treating it like different values. Try using Distinct like below:

Load Distinct

date(Floor(datInkomDAG ),'MMM') as datInkomMÅN,

Load

date(Floor(datInkomDatum)) as datInkomDAG

from A.xlsx;

Let me know if it worked.

Re: date(Floor(MyDate),'MMM')

tresB — Tue, 26 Mar 2019 12:22:58 GMT

May be just Month()

Month(datInkomDatum) as datInkomMÅN

Re: date(Floor(MyDate),'MMM')

AnnaQlik — Tue, 26 Mar 2019 12:26:58 GMT

Thank you Tresesco!! Embarrassingly simple ^^