Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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?
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.
Thank you.....it worked again.