Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Set analysis logic

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 ??

2 Replies
Highlighted
MVP
MVP

Re: Set analysis logic

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

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

Highlighted
MVP
MVP

Re: Set analysis logic

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein