topic Re: Group Date to Month-Year without duplicates in QlikView

Group Date to Month-Year without duplicates

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

Hello dear Qlik Community,

I have dates, which I would like to convert and group on month-year basis, so I could use it as a filter in QS app.

When I do conversion Date(POSTING_DATE,'MM-YYYY') then as a result, I get duplicate results. For example,
for each date, which is in January 2019, I get '01-2019'. However, I would like to have only one '01-2019' per
all the dates, which are in January 2019. How to achieve this?

Thanks
maasool

Re: Group Date to Month-Year without duplicates

Anil_Babu_Samineni — Tue, 21 May 2019 14:29:19 GMT

Perhaps this

Date(Floor(POSTING_DATE),'MM-YYYY')

Re: Group Date to Month-Year without duplicates

martinpohl — Tue, 21 May 2019 14:57:50 GMT

another solution is

date(monthstart(POSTING_DATE),'MM-YYYY')

Your solution is showing only month and year but datas are stored with day also.

Regards

Re: Group Date to Month-Year without duplicates

saar_lorena — Tue, 21 May 2019 19:23:51 GMT

If your data is duplicating, the issue is not with the period...

Can you upload your file here?

Thanks 😃

Re: Group Date to Month-Year without duplicates

maasool — Wed, 22 May 2019 05:39:54 GMT

Thanks for thinking along everyone! Martinpohl solution did the work for me.