Selected value in listbox should only display in table

[hemachandran]

Hi,

  I have four listbox of same field

Eg. Product field as product1

      Product field as product2

      Product field as product3

      Product field as product4

I have four list box

In that product1 listbox  i select tv

           product2 listbox  i select table

           product3 listbox not selected

           product4 listbox not selected 

My requirement is... In straight table i want to display the only selected product ie,

Product          Amount

TV                   10000

Table                 500

I have attached the sample file..

thanks in Advance....              

[varshavig12]

I think that the scenario you have explained does not match with your sample data..

your sample data is just product and amount

Where is your product 1 , product 2 and so on ....?

[hemachandran]

Hi varsha,

I have only one field product..I want to display four listbox. so i renamed product as product1,product2,product3...

In that product1 listbox  i select tv

           product2 listbox  i select table

           product3 listbox not selected

           product4 listbox not selected

My requirement is... In straight table i want to display the only selected product ie,

Product          Amount

TV                   10000

Table                 500

[Anonymous]

Hi Hemachandran,

Use following:

Dimension:-Product

Expression:- sum({<Product={'Tv','Table'}>}Amount)

Here I have assumed that you want to calculate amount for only for Table and Tv

Thanks,

[hemachandran]

Hi Pooja,

Thanks for ur reply..

My requirement is..

  I have four listbox of same field

Eg. Product field as product1

      Product field as product2

      Product field as product3

      Product field as product4

I have four list box

In that product1 listbox  i select tv

           product2 listbox  i select table

           product3 listbox not selected

           product4 listbox not selected

My requirement is... In straight table i want to display the only selected product ie,

Product          Amount

TV                   10000

Table                 500

[varshavig12]

Hi hemachandran d,

I made 4 list box , with alternate states-- ( alternate state is 2,3,4,5 ).

But the problem here I'm facing is that I have to select at least one value from each list box , else it gives me all the values.

I will try to find something with alternate states and let you know.

[hemachandran]

Hi varsha,

Thanks for ur reply..can u send ur QVW file u tried...

[varshavig12]

Sure.

[varshavig12]

Demo

[hemachandran]

Hi Varsha,

Thanks for ur response....