Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Experts,
i have a question regarding my code:
i am just wondering why 2018-Apr. is seen multiple times and not only one time:
Thank you for your support
Best regards Son
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