list box condition?

[#1]

i have listbox called ITEM

ITEM:

D1

D2

E1

E2

here  when i click on D1 respective barchart showing D1's related data  like wise if i click on D2 am getting D2 related data on bar chart as well as for E1 AND E2 also

HERE MY req is  when i clcik on e1 chart shouldnot be refelected and i want e2 data only ?

it means ignoring the selection of e1 and showing the data of e2 when i click on e1 .

for d1 and d2 no need ? 

[sushil353]

in you expression you can try the below code:

if(getfieldselection(ITEM)='E1',Sum({<ITEM={'E2'}>}Sales), Sum(Sales))

HTH

Sushil

[Anonymous]

Hi,

Try this in your expression in chart:

=if(only(GetFieldSelections(ITEM))='e1', sum({<ITEM={'e2'}>} value), sum(value))

Marc.

[#4]

'e1', sum({<ITEM     -  ERROR

SHOWING HERE FOR COMMA   'e1',    this comma is error here

[Anonymous]

Manojqlik,

Please explain further your error or share an example.

Marc.

[#6]

expresiion is wrong

here when i click on e1 i want see e2 result only not e1

e1= e2 result on chart

e2=e2 result on chart

d1=d1 result on chart

d2=d2 result on chart

[Anonymous]

Then the expression should work. Maybe if you share an example with sample data I can try to find out a solution.

Marc.

[mato32188]

Hi manojqlik,

try if(GetFieldSelections(Item) = e1, e2, Item)

BR

M

[sujeetsingh]

Set Trigger for that

Go to Document Properties>>Triggers>> On select of Field>>

Now on select of the field you are using in the List box write select in field Action.

[#10]

TELL ME

how to remove e1 from list box

example:

ITEM:

D1

D2

E1

E2

MY REQ IS

ITEM:

D1

D2

E2               HOW TO REMOVE E1 FROM LIST BOX