topic Re: Can anyone help please? in QlikView

Can anyone help please?

samvile18 — Mon, 10 Feb 2014 11:05:27 GMT

Good morning all,

I have an issue within my QV script that I'm hoping someone can help with.

I have the following table that I'm loading and I want to set the variable vGroupMisc to be the value that's returned in the GroupVariable field.

GroupVariable:

LOAD AppName,

GroupName,

GroupVariable

SQL SELECT *

FROM tblQVGroups

Where (AppName) = '$(vDocName)';

set vGroupName = ????

Can someone help?

Mon, 10 Feb 2014 11:06:15 GMT

PEEK?

samvile18 — Mon, 10 Feb 2014 11:07:55 GMT

Do you happen to know the syntax for the Peek function?

samvile18 — Mon, 10 Feb 2014 11:35:02 GMT

I've figured this out using a combination of the above suggestion and the Lookup funtion.