Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Contributor III

Re: Setting a Condition for a Bar or Combo Chart

Hi Bruce,

Its possible in Qlikview

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

Not applicable

Re: Setting a Condition for a Bar or Combo Chart

Hi Bruce,

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

Use the Expression mentioned above

Regards,

Rohan

MVP
MVP

Re: Setting a Condition for a Bar or Combo Chart

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

Not applicable

Re: Setting a Condition for a Bar or Combo Chart

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.

MVP
MVP

Re: Setting a Condition for a Bar or Combo Chart

I think you missed this ->  '<'

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