https://community.qlik.com/t5/QlikView/Using-expressions-in-ActiveDocument-GetPossibleValues/m-p/1594899#M443833 <P>You could use concat () instead of getPossibleValues()</P><P>&nbsp;</P><P><FONT face="courier new,courier">Concat(Distinct {&lt;Type={'A'}&gt;} Number, ',')</FONT></P> Mon, 24 Jun 2019 05:36:48 GMT Vegar 2019-06-24T05:36:48Z https://community.qlik.com/t5/QlikView/Using-expressions-in-ActiveDocument-GetPossibleValues/m-p/1594897#M443832 <P>Hi,</P><P>Is there any way to do something like this</P><P>set val1=ActiveDocument.Fields("<STRONG>if(type='A', Number)"</STRONG>).GetPossibleValues</P><P>instead of&nbsp;</P><P>set val1=ActiveDocument.Fields("<STRONG>Number</STRONG>").GetPossibleValues</P><P>Jean</P> Sat, 16 Nov 2024 20:36:28 GMT https://community.qlik.com/t5/QlikView/Using-expressions-in-ActiveDocument-GetPossibleValues/m-p/1594897#M443832 jduluc12 2024-11-16T20:36:28Z https://community.qlik.com/t5/QlikView/Using-expressions-in-ActiveDocument-GetPossibleValues/m-p/1594899#M443833 <P>You could use concat () instead of getPossibleValues()</P><P>&nbsp;</P><P><FONT face="courier new,courier">Concat(Distinct {&lt;Type={'A'}&gt;} Number, ',')</FONT></P> Mon, 24 Jun 2019 05:36:48 GMT https://community.qlik.com/t5/QlikView/Using-expressions-in-ActiveDocument-GetPossibleValues/m-p/1594899#M443833 Vegar 2019-06-24T05:36:48Z