Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
maasool
Contributor III
Contributor III

Group Date to Month-Year without duplicates

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

1 Solution

Accepted Solutions
martinpohl
Partner
Partner

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

View solution in original post

4 Replies
Anil_Babu_Samineni

Perhaps this

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
martinpohl
Partner
Partner

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

View solution in original post

saar_lorena
Contributor III
Contributor III

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

Can you upload your file here?

 

Thanks 😃

maasool
Contributor III
Contributor III
Author

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