topic Re: Expression in QlikView

Expression

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Expression

sunny_talwar — Fri, 20 May 2016 03:20:17 GMT

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'

Re: Expression

smilingjohn — Fri, 20 May 2016 03:26:07 GMT

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

Re: Expression

sunny_talwar — Fri, 20 May 2016 03:27:38 GMT

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

Re: Expression

sunny_talwar — Fri, 20 May 2016 03:28:01 GMT

Check out the attachment I have for you below:

Re: Expression

smilingjohn — Fri, 20 May 2016 04:00:00 GMT

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 ?

Re: Expression

sunny_talwar — Fri, 20 May 2016 04:01:15 GMT

Yes, you are absolutely right

Re: Expression

sunny_talwar — Fri, 20 May 2016 04:13:11 GMT

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