Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
mansi_dv
Contributor
Contributor

List Box Presentation


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?

1 Solution

Accepted Solutions
jagan
MVP
MVP

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

View solution in original post

4 Replies
jagan
MVP
MVP

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

View solution in original post

mansi_dv
Contributor
Contributor
Author

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

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
Contributor
Contributor
Author

Thank you.....it worked again.