Discussion Board for collaboration on QlikView Scripting.
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?
May be just Month()
Month(datInkomDatum) as datInkomMÅN
View solution in original post
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:
date(Floor(datInkomDAG ),'MMM') as datInkomMÅN,
date(Floor(datInkomDatum)) as datInkomDAG
Let me know if it worked.
Thank you Tresesco!! Embarrassingly simple ^^