Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Setting a Condition for a Bar or Combo Chart

This may be a simple question since I'm relatively new at Qlik Sense.

My question is whether you can set-up a static condition of filter for a bar or combo chart.  For example I created a simple chart that sums sales and shows them by month.  I have a separate data field which contains sales type.  Is it possible to set up a condition in the Expression so that my chart only shows sale of a unique sales type?

I know I could setup a separate filter pane but was looking for an alternate approach.

5 Replies
ajsjoshua
Specialist
Specialist

Hi Bruce,

Its possible in Qlikview

Sum({<saletype={"whatever"}>}sales)

Not applicable
Author

Hi Bruce,

As Joshua mentioned, it is possible in QlikView as well as QlikSense.

Use the Expression mentioned above

Regards,

Rohan

sunny_talwar

Would you be able to share a sample with expected output to know exactly what you are looking to do?

Not applicable
Author

Thanks for the reply but it doesn't seem to work.  Here is the actual expression I am trying:

Sum({[Account Number]={"4210 Revenue : Sell-through Revenues"}>}[Commission Margin])

Unfortunately it returns no bars on the chart.  What I am trying to accomplish is to display a bar chart that sums commission margin by month for only those orders that are sell-through revenues.

sunny_talwar

I think you missed this ->  '<'

Sum({<[Account Number] = {"4210 Revenue : Sell-through Revenues"}>} [Commission Margin])