topic list box condition? in QlikView

list box condition?

Mon, 01 Dec 2014 10:56:16 GMT

i have listbox called ITEM

ITEM:

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 ?

Re: list box condition?

sushil353 — Mon, 01 Dec 2014 11:00:23 GMT

in you expression you can try the below code:

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

HTH

Sushil

Re: list box condition?

Anonymous — Mon, 01 Dec 2014 11:00:43 GMT

Hi,

Try this in your expression in chart:

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

Marc.

Re: list box condition?

Mon, 01 Dec 2014 11:13:19 GMT

'e1', sum({<ITEM - ERROR

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

Re: list box condition?

Anonymous — Mon, 01 Dec 2014 11:18:34 GMT

Manojqlik,

Please explain further your error or share an example.

Marc.

Re: list box condition?

Mon, 01 Dec 2014 11:46:45 GMT

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

Re: list box condition?

Anonymous — Mon, 01 Dec 2014 11:50:14 GMT

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

Marc.

Re: list box condition?

mato32188 — Mon, 01 Dec 2014 11:53:19 GMT

Hi manojqlik,

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

Re: list box condition?

sujeetsingh — Mon, 01 Dec 2014 11:55:51 GMT

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.

Re: list box condition?

Mon, 01 Dec 2014 11:56:22 GMT

TELL ME

how to remove e1 from list box

example:

ITEM:

MY REQ IS

ITEM:

E2 HOW TO REMOVE E1 FROM LIST BOX

Re: list box condition?

mato32188 — Mon, 01 Dec 2014 11:59:39 GMT

In your list box select expression and write if(Item=e2, null(), Item)

Re: list box condition?

Mon, 01 Dec 2014 12:06:37 GMT

NO STILL SELECTIONS OR REFECTING IN CHART WHEN I CLICK ON E1?

Re: list box condition?

Anonymous — Mon, 01 Dec 2014 12:28:40 GMT

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.

Re: list box condition?

Mon, 01 Dec 2014 12:43:15 GMT

=if(ITEM<>'e1',F1) what is f1 here

Re: list box condition?

Anonymous — Mon, 01 Dec 2014 12:44:25 GMT

Sorry, I meant ITEM insted of F1.

=if(ITEM<>'e1',ITEM)