List Box Presentation

[mansi_dv]

This is in reference to the below discussion

http://community.qlik.com/thread/133770

I attach the file which is there in that discussion.

I wanted to ask:

Can the logic of the number table be applied in a list box?

Or is there some expression/ trigger which can automatically select all the values in the NUMBER table as and when they are generated?

[jagan · Accepted solution]

Hi,

Use this expression in List box

=Aggr(if(count(distinct CODE)=GetPossibleCount(CODE),NUMBER), NUMBER)

New Sheet Object -> List Box-> Select Expression from Field

and give the above expression.

Hope this helps you.

Regards,

Jagan

[mansi_dv]

Hi Jagan,

Thanx for the reply. It worked.

But now I want all the values coming in this list box to be selected as and when they are generated, is this possible?

[jagan]

Hi,

Try like this

Document Properties-> Triggers -> Field Event Triggers-> Click Number-> Onchange-> Add Action-> Add-> Selection-> Select in Field-> Give NUMBER

and below expression.

='(' & Concat(Aggr(if(count(distinct CODE)=GetPossibleCount(CODE),NUMBER), NUMBER), '|') & ')'

Regards,

Jagan.

[mansi_dv]

Thank you.....it worked again.