topic Re: Get only Month in QlikView

Get only Month

bharatkishore — Wed, 14 Feb 2018 07:21:15 GMT

Hi All,

I have a date field with date and time and based on the following expression i removed the time stamp:

(Date(Floor(TecoProxy), 'MM/DD/YYYY')) as Date

Now i need to get only one day and 12 months and the years like

1/1/2015

2/1/2015

3/1/2015

.and so on.

Can you please tell me how can i do it.

Thanks,

Bharat

Re: Get only Month

kristof_j — Wed, 14 Feb 2018 07:31:26 GMT

change your date format into 'D/M/YYYY'

The number of Ds, Ms and Ys defines the length of what you'll see.

D	1
DD	01
M	1
MM	01
MMM	jan
MMMM	january
YY	18
YYYY	2018

Re: Get only Month

petter — Wed, 14 Feb 2018 07:45:08 GMT

Date(MonthStart(Floor(TecoProxy)), 'M/D/YYYY')

If you need to sum up the individual dates for a month you would need to use a GROUP BY clause at the end of your LOAD statement and do a Sum() or other aggregation function on the measures/metrics fields.

Re: Get only Month

bharatkishore — Wed, 14 Feb 2018 09:13:56 GMT

Thanks a lot