topic Re: Unable to define a variable in script level in QlikView

Unable to define a variable in script level

ashis — Fri, 15 Nov 2024 23:14:16 GMT

Hi ,

When i define a variable from application settings -> variable overview and add variable name vVariable and define it as

=date(max(If(if(Instance='XYZ',DATE) > Today()-4, '2000-01-01',if(Instance='XYZ'))),'YYYY-MM-DD')

It returns a date and it is right , but if i define the same variable from the script level as

let vVariable
=date(max(If(if(Instance='XYZ',DATE) > Today()-4, '2000-01-01',if(Instance='XYZ'))),'YYYY-MM-DD')

it through an error saying syntax error, unexpected token ',' expected nothing , and it shows error for this line.

I want to evaluate the value of the variable thus i put let command instead of set . Set does not through an error but pass a string. i want to evaluate the value.

Any idea why it is giving an error with the let statement in the script please.

Thank you,

Re: Unable to define a variable in script level

marcus_sommer — Thu, 28 Jan 2021 13:25:23 GMT

Try it in this way:

set vVariable
= date(max(If(if(Instance='XYZ',DATE) > Today()-4, '2000-01-01',if(Instance='XYZ'))),'YYYY-MM-DD');

- Marcus

Re: Unable to define a variable in script level

ashis — Thu, 28 Jan 2021 14:54:06 GMT

Hi Marcus,

Thank you for your response. Actually i want to evaluate the value in hence suing Let instead of Set as i mentioned in my post.

I want to use the same variable in NPrinting that's the reason i need to do with Let otherwise it is taking as string with Set.

Thank you,

Re: Unable to define a variable in script level

PradeepK — Thu, 28 Jan 2021 15:25:17 GMT

Not sure what is going on inside your if conditions..

But don't you think you need GROUP BY and LOAD statement to use Max() aggregate function in Script.

I hope this helps!

Re: Unable to define a variable in script level

marcus_sommer — Thu, 28 Jan 2021 15:37:54 GMT

Like PradeepK mentioned you will need a load-statement if you want to evaluate any data from tables. After that you could use functions like peek() or fieldvalue() to pick your wanted values from this table and to assign it to a variable.

In your case the efforts for this load seems quite heavy compared to the creation within the UI.

- Marcus

Re: Unable to define a variable in script level

ashis — Fri, 29 Jan 2021 06:09:44 GMT

Thank you Pradeep for your suggestion. Will try that way.

Re: Unable to define a variable in script level

ashis — Fri, 29 Jan 2021 06:10:30 GMT

Hi Marcus,

Yes , i agree. I will try what Pradeep and you mentioned.

Thank you,

Re: Unable to define a variable in script level

Cole_114 — Sat, 13 Feb 2021 12:05:43 GMT

@FaceTime PC wrote:
Hi ,
When i define a variable from application settings -> variable overview and add variable name vVariable and define it as
=date(max(If(if(Instance='XYZ',DATE) > Today()-4, '2000-01-01',if(Instance='XYZ'))),'YYYY-MM-DD')
It returns a date and it is right , but if i define the same variable from the script level as

let vVariable
=date(max(If(if(Instance='XYZ',DATE) > Today()-4, '2000-01-01',if(Instance='XYZ'))),'YYYY-MM-DD')

it through an error saying syntax error, unexpected token ',' expected nothing , and it shows error for this line.
I want to evaluate the value of the variable thus i put let command instead of set . Set does not through an error but pass a string. i want to evaluate the value.
Any idea why it is giving an error with the let statement in the script please.

Thank you ,

It appears to be that since my answer has been posted the naming show has gotten more formal. Individuals who instruct, compose books, and so forth talk about Var affirmation, and capacity assertion.

Here is the extra Wikipedia post that underpins my point: Declarations and definitions .and to respond to the primary inquiry. Pronounce variable before your capacity.