topic Re: Format Changing in QlikView

Format Changing

Fri, 17 Jan 2014 07:02:56 GMT

Hi,

I am having week as 'w1'. I need it to be written as 'W01'.

Is that possible? and could you please suggest me the logic?

Thamks & Regards,

Vinitha Mano R.

Re: Format Changing

Fri, 17 Jan 2014 07:19:15 GMT

Please see the attached example. You would use the code something like this:

LEFT(WeekField,1)&0&RIGHT(WeekField,LEN(WeekField)-1) AS Final

If it was only a 0 for 1-9 and then no zero there after you can sort that with an IF statement.

Let me know if that works.

Dan

Re: Format Changing

Fri, 17 Jan 2014 07:23:28 GMT

This could actually be simplified to:

'W'&0&RIGHT(WeekField,LEN(WeekField)-1) AS Final

Re: Format Changing

Nicole-Smith — Fri, 17 Jan 2014 19:28:27 GMT

Daniel Roberts is on the right track, but both of his solutions add an extra zero for any week greater than one digit (for w10, both of his return w010).

To avoid having the extra 0, here is another option (example.qvw also attached):

'W'&num(PurgeChar(Week, 'w'),'00')

Re: Format Changing

CELAMBARASAN — Fri, 17 Jan 2014 19:33:04 GMT

Try like this

=Num(Num#(FieldName, 'w##'), 'W00')

='W' & Num(Num#(Right(FieldName, Len(FieldName) - 1), '##'), '00')

Re: Format Changing

kiranmanoharrode — Fri, 17 Jan 2014 19:56:42 GMT

Try this

='W'&num(PurgeChar(Week, 'w'),'00')

Re: Format Changing

Anonymous — Fri, 17 Jan 2014 20:25:46 GMT

There are countless ways. Here is one more:

='W' & num(mid(Week,2),'00')