Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
anjaneyulu
Creator
Creator

How to keep excluded values in bar chart?

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

5 Replies
sunny_talwar

May be use an expression like this:

Sum({<Country = >}Sales)

and a background color expression like this:

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

sunny_talwar

Sample attached

Capture.PNG

MarcoWedel

Hi,

some similar solution:

QlikCommunity_Thread_223017_Pic1.JPG

QlikCommunity_Thread_223017_Pic2.JPG

QlikCommunity_Thread_223017_Pic3.JPG

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

anjaneyulu
Creator
Creator
Author

Thank you

MarcoWedel

you're welcome.

please close this thread if your question is answered.

thanks

regards

Marco