topic Let statement passes dual value as Text value? in QlikView

Let statement passes dual value as Text value?

atsushi_saijo — Wed, 12 Oct 2016 07:36:37 GMT

Hi Gurus,

I have a suspicion that dual values (such as date) in let statement cannot handle it as dual value, but rather a value (typically text).

For example, if I use:

Let vTest = Date(Today(), 'YYYY-MM');

Then $(vTest) is no longer dual value, but a text string of '2016-10'. Is this correct understanding?

I would appreciate for your feedback in advance.

Re: Let statement passes dual value as Text value?

sunny_talwar — Wed, 12 Oct 2016 08:57:26 GMT

I think you are sort of right, if the date format is not the same as the format from environmental variable, it will save it as text. That is why I usually try to store date as number in variables and then we can always convert them into date using date functions

Let vTest = Num(Today());

and then you can use it in script

Where OrderDate <= $(vTest);

Re: Let statement passes dual value as Text value?

Peter_Cammaert — Wed, 12 Oct 2016 09:03:32 GMT

Variables cannot store dual values. Dual values are a QlikView (field) concept and variables came for free with the Microsoft VBScript language. It's a pity though...

VBScript variables are untyped however (variant), so I'm not sure that they only store text values. It often looks that way.