topic Re: date format in QlikView

date format

prabhas277 — Sun, 05 Jul 2015 16:17:50 GMT

Hi experts,

i have one field called month in that i have some data .the data like jan-14,fed-14 ...dec-14 now in list the data is like 1/1/14,2/1/14 like that. now my requirement is that will apper in the list box like jan-14,feb-14 like how we can achive that?

Regards,

prabhas,

Re: date format

Anonymous — Sun, 05 Jul 2015 16:26:11 GMT

Hi,

can you post sample data?

Is simplier to understand.

Thank you.

Regards.

Re: date format

swuehl — Sun, 05 Jul 2015 16:27:45 GMT

Try

LOAD

MonthName(month) as month,

....

in your load script.

Re: date format

hari8088 — Sun, 05 Jul 2015 16:28:04 GMT

can u give more explanation

Re: date format

settu_periasamy — Sun, 05 Jul 2015 16:29:40 GMT

Hi,

You mentioned already you have month field like Jan-14, Feb-14.

You can directly put that in your listbox, right?

if you have the date field, then in the listbox Expression give

like this

=Date([Your date field],'MMM-YY')

Re: date format

sunny_talwar — Sun, 05 Jul 2015 16:34:31 GMT

Try this in the script:

Date(Date#(Capitalize(Month), 'MMM-YY')) as Date,

MonthName(Date#(Capitalize(Month), 'MMM-YY')) as MonthYear