topic List Box Presentation in QlikView

List Box Presentation

mansi_dv — Thu, 25 Sep 2014 07:59:26 GMT

This is in reference to the below discussion

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 — Thu, 25 Sep 2014 08:11:47 GMT

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 — Thu, 25 Sep 2014 08:50:17 GMT

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 — Thu, 25 Sep 2014 08:58:50 GMT

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 — Thu, 25 Sep 2014 09:12:12 GMT

Thank you.....it worked again.