Discussion Board for collaboration related to QlikView App Development.
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?
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.
View solution in original post
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?
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), '|') & ')'
Thank you.....it worked again.