Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
In your list box select expression and write if(Item=e2, null(), Item)
NO STILL SELECTIONS OR REFECTING IN CHART WHEN I CLICK ON E1?
Manojqlik,
I think you are mixing different requirements.
If you want to show an specific calculation for an specific selection (if you select e1, show e2) then use the expression I gave you.
If you want to exclude e1 from listbox, then use the expression below:
=if(ITEM<>'e1',F1)
If you want to "autoselect" e2, then set a trigger in document properties.
Marc.
=if(ITEM<>'e1',F1) what is f1 here
Sorry, I meant ITEM insted of F1.
=if(ITEM<>'e1',ITEM)