Expression

[smilingjohn]

Hi All i have a chart (bar ) which has tree expression

Department  (Count of Dept)

Employee (Count Empl)

Revnue(Sum Rev)

at the top of this chart i have a list box which has Dept,Empl,Rev

Now  i want to know , if i click on dept it should show me Department bar graph , if i select emp it should show only Employee bar and so on .

So how do we do this becuase dept ,Empl and Revenue are inline statement .

from ther i have taken them ar a led check box list box.

[sunny_talwar]

There are multiple ways to do this. You can make the three expressions conditional is one way to do this:

Condition for the 1st expression would be -> ListBoxField = 'Dept'

Condition for the 2nd expression would be -> ListBoxField = 'Empl'

Condition for the 3rd expression would be -> ListBoxField = 'Rev'

[smilingjohn]

Thanks sunny but i did not understand , you mena to say that in expression i need to mention this ?

[sunny_talwar]

Please find attached a sample where I have tried to implement the above logic +  another logic where I specify the expressions in the script itself.

Method1

[sunny_talwar]

Check out the attachment I have for you below:

[smilingjohn]

hi sunny ,

thanks Sunny just wanted to know is the list box name here is Selection ?

We need to specify the Field name of the list box and then cintent in that right ?

in my case the listbox field name is Hierarchy , and i need to specify like Hierarchy=Dept ?

[sunny_talwar · Accepted solution]

Yes, you are absolutely right

[sunny_talwar]

John -

I would like to thank you for marking my response as correct, but please mark a response which actually helped you get to what you wanted. Imagine how people with similar problem in the future would see when they land on this page?

Lets give them something more helpful then just a statement that Yes, you are right.

Qlik Community Tip: Marking Replies as Correct or Helpful‌

Thanks for your time and effort

Best,

Sunny