Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SonPhan
Partner - Creator
Partner - Creator
‎2021-09-02 11:05 AM

Weird selections

Hello Qlik Experts,

i have a question regarding my code:

SonPhan_2-1630594999092.png

i am just wondering why 2018-Apr. is seen multiple times and not only one time:

SonPhan_1-1630594987981.png

Thank you for your support

 

Best regards Son

300 Views
0 Likes
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2021-09-02 01:55 PM

It's because the Date() function formats for display but does not modify the internal value.  The values of Datum still contain different days of the month, so are different values. When you create Dataum, you want to harmonize all the values to the first day of the month using MonthStart().

Date(MonthStart([RW.DAT], 'YYYY-MMM') as Datum

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

269 Views