Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

jduluc12
Contributor

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

1 Reply
Partner
Partner

Re: Using expressions in ActiveDocument GetPossibleValues

You could use concat () instead of getPossibleValues()

 

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes