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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
jduluc12
Creator
Creator

Using expressions in ActiveDocument GetPossibleValues

Hi,

Is there any way to do something like this

set val1=ActiveDocument.Fields("if(type='A', Number)").GetPossibleValues

instead of 

set val1=ActiveDocument.Fields("Number").GetPossibleValues

Jean

Labels (1)
1 Reply
Vegar
MVP
MVP

You could use concat () instead of getPossibleValues()

 

Concat(Distinct {<Type={'A'}>} Number, ',')