topic Format changing in QlikView

Format changing

Mon, 13 Jan 2014 08:01:13 GMT

Hi,

Is it possible to write 2014/w01 as 2013 w01?

If yes, can anyone please tell the logic

Thanks & Regards,

Vinitha.

jonathandienst — Mon, 13 Jan 2014 08:04:44 GMT

Not sure what you want. Assuming it is to change "2014/w1" to "2014 w1" then

Replace('2014/w1', '/', ' ')

HTH

Jonathan

Sokkorn — Mon, 13 Jan 2014 08:05:48 GMT

Hi Vinitha,

Yes, it can. Let try:

=Replace('2014/w01','/',' ')

Year(DateField) & ' w' & Num(Week(DateField))

Regards,

Sokkorn

Michiel_QV_Fan — Mon, 13 Jan 2014 08:17:49 GMT

If your goal is to subtract 1 year from 2014:

addyears(Year(DateField), -1) & ' w' & Num(Week(DateField))

Mon, 13 Jan 2014 08:40:42 GMT

Hi Jonathan,

Thank you for your answer. It really helped me.

Thanks & Regards,

Vinitha.

Mon, 13 Jan 2014 08:40:55 GMT

Hi,

Not sure if I understand you correctly, per my understanding you want to change '/' to space, so you can use:

Replace(2014/w01, '/', ' ')

It will give you 2014 w01)

If you want to use it for a fieldname then :

Replace([DateNum], '/', ' ')

Where DateNum is the fieldname.

Hope this helps!