I need output some thing like this x1,x2,x3....xn

[Anonymous]

I need output some thing like this x1,x2,x3....xn

thanks

[amit_saini]

rgv,

Good question . Could you please share your requirement with sample may be we can suggest you some other approach .

Thanks,

AS

[Anonymous]

Hi i would like to know can we make dynamically rather than static

something like "X'&

[amit_saini]

Like this:

Try in script

'X' & MonthName as Key

Thanks,
AS

[Anonymous]

actually i am a beginner in qlikview i dosen't have any document .my requirement is to change month names jan to dec as x1 to x12 .

Thanks

[MarcoWedel]

='X'&Num(Month(Date#(yourmonthfield,'MMM')))

[MarcoWedel]

in case yourmonthfield is already dual:

='X'&Num(Month(yourmonthfield))

[PrashantSangle]

Hi,

Try like

'X'&Date(datefield,'MM') as Newfield

or

try like

'X'&Date(Date#(datefield,'MMM'),'MM') as Newfield

Regards

[Anonymous]

Thanks MaxDreamer yours answer is also working

[engishfaque · Accepted solution]

Dear RGV,

Here it is.

'x' & AutoNumber(Month_Name) as NewName

Kind regards,

Ishfaque Ahmed

[Anonymous]

actually i have tried the same with autonumber but it doesn't worked for me ,But yours is working .

thank u  Ishfaue Ahmed

Thanks

RGVRand