Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Expression in a List Box

i want to implement multiple expression inside a list box like this

For a single row execution i want to add more than one values to a list box.

Sample Scenario:

For example i have to show two calculated expression in a single list box.

For example i want to show count(Field1) and Sum(Field2) inside a single list box.

I tried this count(Field1) & sum(Field2) which concat the result into a single value. If or switches are executing anyone only. How can i achieve this.

6 Replies
Not applicable
Author

OR i atleast want to concatenate two list box items into a single list box item via the list box expression.

Hope Everything is Possible...

sparur
Specialist II
Specialist II

Hi Dora

What you want achieve by this "complex" listbox? 🙂 If you want to see only result of evaluating your expressions: count(Field1) and sum(Field2) so why you can't to use a text object with expression such as:

='count values in Field1=' & count(Field1) & chr(10) & 'Sum of values in Field2=' & sum(Field2)

Not applicable
Author

This is not my complete requirement, I want this functionality in my work. I need similiar function in my work very much.This is simply a forming a new field like thing in front UI. Its easy to achieve this in script.But i want to show few things mingled in a single list box using condition.

sparur
Specialist II
Specialist II

Do You want to create a new field(Listbox ) in dynamically (in UI) ? Could you give an example of your simple real task in qvw?

Not applicable
Author

sure...This is a sample real time environment.

I executed an expression and filtered some data in a field((list box), now am having another expression also, which to be executed and the result to be present in the same list box with old result.

expression1 returns a,b,c as results. Now having expression2 returns d,e,f. Now i want to display both the result in the same listbox without losing any previous expression result.

sparur
Specialist II
Specialist II

could you give a small sample of qvw?