topic Re: Set analysis logic in QlikView

Set analysis logic

Pulkit_Thukral — Mon, 07 Sep 2015 13:19:19 GMT

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 — Mon, 07 Sep 2015 13:24:03 GMT

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

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

jonathandienst — Mon, 07 Sep 2015 13:34:33 GMT

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)