topic Re: year month issue in QlikView

year month issue

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

Hi All,

i have a date column

calendarDate

11/01/2019

11/02/2019

12/01/2020

10/01/2019

so i want output like

Oct-19

Nov-19

Dec-20

i used below but im getting

Date(calendarDate,'MMM-YY') as Mydate

but result in listbox i can seee

Oct-19

0ct-19

oct-19

Nov-19

months is showing duplicates .. usaally listbox show distinct values right?

tresB — Fri, 19 Jun 2020 05:32:15 GMT

Try like:

Date(MonthStart(calendarDate),'MMM-YY') as Mydate

karthiccr — Fri, 19 Jun 2020 05:47:00 GMT

Hi,

The data is still interpreted as Date type. try converting to String using TEXT.

Text(Date(Date#(F1,'DD-MM-YYYY'),'MMM-YY')) as MMMYY;

Thanks,

karthik

soniasweety — Fri, 19 Jun 2020 06:06:40 GMT

Thank you its working fine .

soniasweety — Fri, 19 Jun 2020 06:07:17 GMT

its not working. showing blank .