topic Date Format in QlikView

Date Format

upaliwije — Tue, 11 Feb 2014 06:35:34 GMT

='Premium ' & (Max(R_YEAR)) &'-'& (Max(R_MONTH))

when I use above label in a chart the result is 2013-1 , 2013-2 etc.

I want the label to display as follows

2013-JAN 2013-FEB

pls help me to rewrite the above expression correctly

Re: Date Format

sujeetsingh — Tue, 11 Feb 2014 06:44:22 GMT

Use this

='Premium ' & (Max(month(R_YEAR))) &'-'& (Max(month(R_MONTH)))

Re: Date Format

jjordaan — Tue, 11 Feb 2014 06:49:56 GMT

Use

='Premium ' & (MAX(YEAR(R_YEAR))) &'-'& (MAX(MONTH(R_MONTH)))

Re: Date Format

Anonymous — Tue, 11 Feb 2014 06:59:24 GMT

Can you try ='Premium' & (YEAR(MAX(R_YEAR))) & '-'&(MONTHNAMES(MAX(R_MONTH))).

Re: Date Format

MayilVahanan — Tue, 11 Feb 2014 07:07:13 GMT

Try like this

='Premium ' & (MAX(YEAR(Today()))) &'-'& (MONTH(Today()))

Gives result as "Premium 2014-Feb"

Edit:

='Premium ' & (MAX(YEAR(Today()))) &'-'& Upper(Month(Max(Today())))

Gives result as "Premium 2014-FEB"

Re: Date Format

Sokkorn — Tue, 11 Feb 2014 07:13:11 GMT

Hi Upali,

Use this

='Premium ' & (Max(R_YEAR)) &'-'& Pick(Max(R_MONTH),'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

Regards,

Sokkorn

Re: Date Format

amit_saini — Tue, 11 Feb 2014 07:15:56 GMT

Hi Upali,

Try this:

Year(Datefield) & ' / ' & Month(Datefield)

Thanks,

Re: Date Format

ashwanin — Tue, 11 Feb 2014 07:20:25 GMT

='Premium ' & (MAX(YEAR(R_YEAR))) &'-'& (MAX(MONTH(R_MONTH)))

Re: Date Format

sunilkumarqv — Tue, 11 Feb 2014 07:20:43 GMT

Copy and past this in your script. Its working in my text box

='Premium' & (YEAR(MAX(R_YEAR))) & '-'&(month(MAX(R_YEAR)))

='Premium' & (YEAR(MAX(Today()))) & '-'&(month(MAX(Today()-30))) & ' '& 'Premium' &(YEAR(MAX(Today()))) & '-'&(month(MAX(Today())))

Re: Date Format

Tue, 11 Feb 2014 07:22:59 GMT

Hi Upali,

Try to this

='Premium ' & (Max(R_YEAR)) &'-'&

='Premium ' & (MAX(YEAR(Today()))) &'-'& Upper(Month(Max(Today())))

and jeroen also put right expression try to both

Regards,

Re: Date Format

Tue, 11 Feb 2014 07:37:59 GMT

Hi,

If your R_MONTH filed is numeric then try below expression,

='Premium ' & (Max(R_YEAR)) &'-'& (Date(DATE#(MAX(R_MONTH),'M'),'MMM') )