Display possible selection

[#1]

Hello everybody,

I want to display in my macro a possible value of list selection, i know fonction like Getfielfselection(field), but is there a function to get a possible value (white color value)?

Best regards.

[#2 · Accepted solution]

Hu Attalah,

Try with something like following:

=concat(distinct YourField, ', ')

Regards.

[#3]

Thx Miguel your solution work.

Rgds.

[#4]

I want use cancat expression in a if, something like:

if( GetPossibleCount("Activity status")=1 and concat(distinct Myfield,', ')<>'Ok')

then ....

end if

Why The concat dont work in this case?

[#5]

Hi Attalah,

Certainly, I don't know what are you looking for, could you be more specific?

I've make the following example and it works:

=If(Concat(MyField,', ') = 'Ok', 1,2)

Regards.

[#6]

I want to use concat in a macro, is it possible?

[#7]

No, you can't but you could use a variable using the concat expression and read the result in the macro code.

Regards.

[johnw]

Attalah Abdelhamid wrote:I want to use concat in a macro, is it possible?

You can use activedocument.evaluate() to get the value of normal QlikView expressions. So you should be able to use this in a VB macro:

activedocument.evaluate("concat(MyField,', ')")

[#9]

Hi john,

Finaly i have used a variable, and my code becomes:

set vok = ActiveDocument.Fields("Mill status").GetPossibleValues

if (vok.count=1 and vok.Item(0).Text="Ok") then

XLSheet.Range("A1").Value="All Mill status = Ok"

XLsheet.Cells.EntireColumn.AutoFit

XLsheet.Cells.EntireRow.AutoFit

else

table.CopyTableToClipboard true 'Copy data to Clipboard

XLSheet.Paste XLSheet.Range("A1")

XLsheet.Cells.EntireColumn.AutoFit

XLsheet.Cells.EntireRow.AutoFit

end if