Set analysis logic

[Pulkit_Thukral]

Hi,

i am writing an expression using set analysis which is Showing distinct count for available devices .

This task has been done .BUT if i want to directly list all the devices in a list box  then what shall i write in the expression .

Attaching the dummy code that i used for the count of available devices.

Count ({< Call__MonthSerial={"<=$(=$(vMaxSelectedMonth))"},

Call_Month=,[Call_Day of Month]={"<=$(=$(vMaxSelectedDay))"},Call_Year= >} DISTINCT device)

This will give me the count of devices from the very start .

But i want a list of all these available devices in a list box and not the the count.

In place of count function what shall i use for it ??

[MK_QSL]

CONCAT({< Call__MonthSerial={"<=$(=$(vMaxSelectedMonth))"},

Call_Month=,[Call_Day of Month]={"<=$(=$(vMaxSelectedDay))"},Call_Year= >} DISTINCT device,', ')

[jonathandienst]

For a list box, use this as the expression:

=Aggr(Only({< Call__MonthSerial={"<=$(=$(vMaxSelectedMonth))"},

Call_Month=,[Call_Day of Month]={"<=$(=$(vMaxSelectedDay))"},Call_Year= >} DISTINCT device), device)