topic Re: Collect the allowable, but not selected values in Qlik NPrinting

Collect the allowable, but not selected values

JustinDallas — Wed, 03 Jun 2015 15:10:50 GMT

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.

Re: Collect the allowable, but not selected values

m_woolf — Wed, 03 Jun 2015 16:21:35 GMT

This can be done with macros:

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

for i=0 to val.Count-1

msgbox(val.Item(i).Text)

Re: Collect the allowable, but not selected values

Colin-Albert — Wed, 03 Jun 2015 16:27:48 GMT

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

Filters & Cycles – Customer Feedback for Vizubi