topic Re: How to keep excluded values in bar chart? in QlikView

How to keep excluded values in bar chart?

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

Hi,

My Requirement is when i select country in listbox the bar chart have to show selected country sales and excluded sales and selected value have to show different color or size.

Thank you in advance

Anji

Re: How to keep excluded values in bar chart?

sunny_talwar — Wed, 29 Jun 2016 16:12:16 GMT

May be use an expression like this:

Sum({<Country = >}Sales)

and a background color expression like this:

If(Sum(Sales) > 0, Red(), Blue())

Re: How to keep excluded values in bar chart?

sunny_talwar — Wed, 29 Jun 2016 16:14:50 GMT

Sample attached

Re: How to keep excluded values in bar chart?

MarcoWedel — Wed, 29 Jun 2016 23:42:51 GMT

Hi,

some similar solution:

Sunny's expression might suit your requirement better though, if your chart shall still react to selections in other fields than "country".

hope this helps

regards

Marco

Re: How to keep excluded values in bar chart?

Akina0929 — Thu, 30 Jun 2016 05:41:11 GMT

Thank you

Re: How to keep excluded values in bar chart?

MarcoWedel — Thu, 30 Jun 2016 20:48:14 GMT

you're welcome.

please close this thread if your question is answered.

thanks

regards

Marco