topic Multiple Expression in a List Box in QlikView

Multiple Expression in a List Box

Wed, 10 Mar 2010 05:58:00 GMT

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.

Multiple Expression in a List Box

Wed, 10 Mar 2010 10:21:24 GMT

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

Multiple Expression in a List Box

sparur — Wed, 10 Mar 2010 10:28:09 GMT

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)

Multiple Expression in a List Box

Wed, 10 Mar 2010 10:52:06 GMT

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.

Multiple Expression in a List Box

sparur — Wed, 10 Mar 2010 11:07:00 GMT

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?

Multiple Expression in a List Box

Wed, 10 Mar 2010 11:44:34 GMT

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.

Multiple Expression in a List Box

sparur — Wed, 10 Mar 2010 11:51:06 GMT

could you give a small sample of qvw?