Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

Collect the allowable, but not selected values

Hello Everyone,

Is there a way I can get a string of the "allowable" values in a field?  I have an NPrinting report that is selecting on one field, but my report header uses the selections from another field.  With selections, you have "GetFieldSelections", but I don't seem to be able to find a "GetFieldAllowableSelections".

Any help is greatly appreciated.

2 Replies
m_woolf
Master II
Master II

This can be done with macros:

set val=ActiveDocument.Fields("Month").GetPossibleValues

for i=0 to val.Count-1

    msgbox(val.Item(i).Text)

next

Colin-Albert
Partner - Champion
Partner - Champion

It may be worth checking NPrinting forums as you may be able to do this via Filters,.

Filters & Cycles – Customer Feedback for Vizubi