Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

list box condition?

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 ? 

14 Replies
mato32188
Specialist
Specialist

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

ECG line chart is the most important visualization in your life.
Not applicable
Author

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

Anonymous
Not applicable
Author

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.

Not applicable
Author

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

Anonymous
Not applicable
Author

Sorry, I meant ITEM insted of F1.

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