topic Regarding date format? in QlikView

Regarding date format?

d_koti24 — Thu, 22 Oct 2015 09:56:11 GMT

Hi All,

I have two fields like month,and year

Month	Year
3	2015
4	2015
5	2015
6	2015
7	2015

i want to display monthyear in List box

like Monthyear:2015-03,2015-04,-----2015-07

How to achive this?

regards,

Re: Regarding date format?

marcus_malinow — Thu, 22 Oct 2015 09:57:59 GMT

You can either modify your load script to assemble the field as

Year & '-' & Num(Month,'00')

Or use this as a calculated dimension

Re: Regarding date format?

settu_periasamy — Thu, 22 Oct 2015 10:02:12 GMT

Hi,

Add the Field in Script like below.

Load *,Date(Date,'YYYY-MM') as YearMonth;

Load *,MakeDate(Year,Month) as Date;

LOAD * INLINE [

Month, Year

3, 2015

4, 2015

5, 2015

6, 2015

7, 2015

];

Re: Regarding date format?

rubenmarin — Thu, 22 Oct 2015 10:02:39 GMT

If you want it in date DataType, so you can use date functions if needed:

Date(MakeDate(Year, Month), 'YYYY-MM')

Re: Regarding date format?

jagan — Thu, 22 Oct 2015 10:08:22 GMT

Hi Koti,

Try like this

LOAD

Month,

Year,

Date(MakeDate(Year, Month), 'YYYY-MM') AS MonthYear

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Regarding date format?

Gabriel — Thu, 22 Oct 2015 10:22:46 GMT

Hi,

Try this

Temp_Data:

LOAD * INLINE [

Month, Year

3, 2015

4, 2015

5, 2015

6, 2015

7, 2015

];

Final:

LOAD

Date(MakeDate(Year, Month),'YYYY-MM') AS [Yr Mnth]

Resident Temp_Data

Order By Year, Month DESC

;

DROP Table Temp_Data;

Re: Regarding date format?

MarcoWedel — Thu, 22 Oct 2015 22:42:00 GMT

Hi,

if you don't want to change your script, you could use a calculated list box with the already proposed expressions.

Some solutions could be:

hope this helps

regards

Marco