How to display in the listbox along with min and max values?

[jagannalla]

Hi,

In my qvd file i've different number of fields. I want to divide this fields into few groups and display in this listbox along with there min & max value in the expression.

First, the fields in qvd say A1,A2,A3,B1,B2,B3,C1,C2,C3....etc. For each field i'm able to catch min and max values. But how can i show in one listbox all A groups along with min and max values.

For Eg:

I want to see in the listbox like this:

GroupA        Min   Max

A1                3      5

A2                2      4

A3                5      10

[jagannalla]

To achive this i had taken seperate excel with columns GroupA, Min, Max.

so that i can see as above post structure in the listbox. But when qvd file data is updated the field values data will be changed. I'll face the problem at dat time so, i want to update this excel file also.

How can i overcome this. Whether it is possible to do it.

Can anyone help me on this problem otherwise give me few ideas in different format to achive this.

- Why i'm trying this b'coz the user can able to choose his own fields from different number of fields in listbox. At the end he can see only those fields in output. I did all this things but i got struct when the qvd file is updated.

[nagaiank]

Did you try listbox with expressions?

[#4]

Hi,

You can try creating a table box with these 3 columns Group, Min and Max so user can see the groups and their min and maxes next to them.

Or try attaching the sample data.

Cheers.

[jagannalla]

Krishnamoorthy / BlacRock S,

- Krishnamoorthy.. i tried with listbox only. But in the listbox we can't display all fields at a time. To achive this we need to take seperate field(i.e GroupA) and data for this field is fields of qvd file(i.e A1,A2,A3..). And one more point is we need to display Min & Max values of A1,A2,A3.. with field Min & Max then only we can see the data in the listbox.

- BlackRock S.... In tablebox we can provide checkboxes, it is possible with listbox only. The user needs to select this own fields only. After selecting in the listbox i'm storing all selections in one variable.

[kaushiknsolanki]

Hi,

    According to my understanding you can try this.

    Create a list box, with expression.( in properties ->General Tab-> Fields -> Expression) Type expression as

    =if(wildmatch(FIeld1,'A*'),Value)

    For Group A

    and in expression tab.

    Create two expression as MIn(Value) and Max(Value)

Regards,

Kaushik Solanki       

[jagannalla]

I didn't get what your are saying. What is the Value here.

- I'm attaching sample qvw file. Can you please see it once.

[jagannalla]

kaushik,

Did you understood what i said. Can you please respond to my post.

[#9]

Hi,

you need to change the way data is loading, please see if the attached can give you some direction.

Cheers.

[jagannalla]

BlackRock S,

It's good actually. But how can i create Data,Val fields in qvd file. I'm attaching sample qvd file . Can you do it on that qvd file. B'coz you have taken excel sheet and created Data,Val fields manually i think. But how to get all those thinks along with single qvd file.

Please sorry to ask again.