topic Re: Explain the syntax? in QlikView

Explain the syntax?

Wed, 29 Oct 2014 09:44:58 GMT

Hi,

Can you plz explain this below syntax.

if my date is 12/02/2014 then what will happen using this below syntax.

right(repeat(0,1)&subfield(date(date),'/',1),2)

ashfaq_haseeb — Wed, 29 Oct 2014 09:49:04 GMT

If it is 5/02/2014 it will return 05

Regards

ASHFAQ

alexandros17 — Wed, 29 Oct 2014 09:49:17 GMT

right(repeat(0,1)&subfield(date(date),'/',1),2)

Transform date to a date format -> date(date)

Then with subfield take the first part of the date : if 7/06/2014 it takes 7

The repeat repeat the char 0 1 time so you have a string 0 concatenated to 7

at the ent it takes only the 2 char to the right

Wed, 29 Oct 2014 09:51:12 GMT

Hi Ashfaq,

What is the use of repeat(0,1) here?

ashfaq_haseeb — Wed, 29 Oct 2014 09:53:44 GMT

I just explained.

If you date is 5/02/2014.

It will add leading zero. Here o/p will be 05.

Regards

ASHFAQ