topic Re: Using quotes in variable in QlikView

Using quotes in variable

Tue, 12 May 2015 18:48:39 GMT

Hi,

I am trying to define a variable to give a value like

WHERE trunc(pxcreatedatetime) >=to_date('10/3/2014','DD/MM/YYYY')

Here is what I am trying but it's not working:

LET INCREMENTAL_EXP = 'WHERE trunc(pxcreatedatetime) >=' & 'to_date(' &'char(39)'& fieldValue('maxdate', 1) &'char(39)' & ')';

In the above statement, maxdate gets resolved successfully to 10/3/2014. I am looking for way to insert quotes before and after 10/3/2014.

Thanks,

Sudha.

rwunderlich — Tue, 12 May 2015 18:57:58 GMT

I find it easiest to use a proxy character and then replace().

LET INCREMENTAL_EXP = replace('WHERE trunc(pxcreatedatetime) >=to_date(|10/3/2014|,|DD/MM/YYYY|)','|',chr(39));

-Rob

Tue, 12 May 2015 19:01:16 GMT

Thanks Rob. It works.

pokassov — Tue, 12 May 2015 19:09:03 GMT

Hello!

Let INCREMENTAL_EXP='where trunc(pxcreatedatetime)>=to_date('&Chr(39)&Today()&Chr(39)&',''DD/MM/YYYY'')';

Thu, 14 May 2015 20:28:36 GMT

Thank you so much. This helped