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 you expression you can try the below code:
if(getfieldselection(ITEM)='E1',Sum({<ITEM={'E2'}>}Sales), Sum(Sales))
HTH
Sushil
Hi,
Try this in your expression in chart:
=if(only(GetFieldSelections(ITEM))='e1', sum({<ITEM={'e2'}>} value), sum(value))
Marc.
'e1', sum({<ITEM - ERROR
SHOWING HERE FOR COMMA 'e1', this comma is error here
Manojqlik,
Please explain further your error or share an example.
Marc.
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
Then the expression should work. Maybe if you share an example with sample data I can try to find out a solution.
Marc.
Hi manojqlik,
try if(GetFieldSelections(Item) = e1, e2, Item)
BR
M
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.
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