Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

samvile18
Contributor II

Can anyone help please?

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?

1 Solution

Accepted Solutions
samvile18
Contributor II

Re: Can anyone help please?

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

3 Replies
Not applicable

Re: Can anyone help please?

PEEK?

Highlighted
samvile18
Contributor II

Re: Can anyone help please?

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

samvile18
Contributor II

Re: Can anyone help please?

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