topic Re: Correct formatting for a date object in QlikView

Correct formatting for a date object

Anonymous — Mon, 10 Jul 2017 18:54:44 GMT

Hello,

I have a date object entitled MonthandYear (i.e. 'Jun-2017') and currently in the process of using the following formula:

='(' & concat({$} distinct chr(34) & MONTHandYEAR & chr(34),'|') & ')'

The result is a listing of dates formatted this way (i.e. ("42736"| "42767" | "42795"). How can I changed the formula above to show the dates as they are in the object (..e. 'Jun-2017'). I've tried solving this myself but for some reason am having an issue with it.

Thanks for your help.

Re: Correct formatting for a date object

sunny_talwar — Mon, 10 Jul 2017 18:56:11 GMT

Try this

='(' & Concat({$} DISTINCT Chr(34) & Date(MONTHandYEAR, 'MMM-YYYY') & Chr(34),'|') & ')'

Re: Correct formatting for a date object

Anonymous — Mon, 10 Jul 2017 20:15:37 GMT

Hi Sunny,

Thanks for the help. It worked. Not sure why I could not get it to work on my own.

Thanks again for all of your help.

Re: Correct formatting for a date object

sunny_talwar — Tue, 11 Jul 2017 08:54:02 GMT

Awesome!!! I am glad I was able to help.

Best,

Sunny