topic Re: reply urgent please in QlikView

reply urgent please

Wed, 05 Jun 2013 03:55:06 GMT

Hi...i have a column Fiscal Month (please find the attachment) , in that months are displying like 1,2,3,4,...but my issue is need to disply 1 as JAN ,2 as FEB......, It is possible can anyone please help me to get this...

Thanks & Regards,

Sh.

Re: reply urgent please

Sokkorn — Wed, 05 Jun 2013 03:59:21 GMT

Hi Sh.,

You can create below expression

=Pick([FiscalMonthNumber],'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

Where [FiscalMonthNumber] is your month number field.

Regards,

Sokkorn

Re: reply urgent please

Wed, 05 Jun 2013 04:07:56 GMT

Hi..Thanks For that Reply, But where i have to give that expression ...in the script level or some where?....i need to show FiscalMonthNumber as a list box...

Regards,

Sh.

Re: reply urgent please

Sokkorn — Wed, 05 Jun 2013 04:09:53 GMT

Hi Sh.,

Do this: Create new List Box -> In drop down Field choose <Expression> -> past expression here

Regards,

Sokkorn

Re: reply urgent please

Wed, 05 Jun 2013 04:17:05 GMT

Or else

if want at the script level,

create inline

Fiscal Month, Display Month

1, JAN

2, FEB

3, MARCH

then just link both the fiscal months and use Display Month in the list box.

tht will solve ur problem.

Re: reply urgent please

Wed, 05 Jun 2013 05:48:46 GMT

Can you upload your sample application.

Re: reply urgent please

er_mohit — Wed, 05 Jun 2013 06:24:47 GMT

I think You have To try this in script

NameMap:

mapping LOAD * INLINE [

FiscalMonthNumber, FiscalMonthName

1, JAN

2, FEB

3, MAR

4, APR

5, MAY

6, JUN

7, JUL

8, AUG

9, SEP

10, OCT

11, NOV

12, DEC

];

Map FiscalMonthNumber using NameMap;

LOAD * INLINE [

FiscalMonthNumber

];

hope it helps