Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Make FieldValueList available in the whole script

Vegar
MVP
MVP

Make FieldValueList available in the whole script

FieldValueList is an useful feature in the for each ... next loop, but it would also be quite useful in the rest of the script. 

Today we can accomplish the same as an FieldValueList function would do by the following script.

FieldValues:
LOAD Concat(Chr(39) & [Field] & Chr(39), ',') as FieldValueList; LOAD Field FROM SOURCE;
LET vFieldValueList = Peek('FieldValueList',-1,FieldValues);
DROP TABLE FieldValues

It would be easier and more available for all developers if the same output would be available from this command.

LET vFieldValueList = FieldValueList('Field');

As it is available in the for each ... next loop I would guess that it could not big a deal to open up for using it in the rest of the script

3 Comments
Patric_Nordstrom
Employee
Employee

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

Status changed to: Open - Collecting Feedback
Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived