Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mpalha
Contributor III
Contributor III

Color or Mini Chart Expression for Table Values

Hello,

I have the table below which shows the share of investment and sales for specific products. I'd like to visualize this better by either having mini bars that correspond to their share (i.e. 67% has a bigger bar than 3.6%) or by having a font color expression that corresponds to their relative value to the total. How do I go about doing this?

mpalha_0-1625506860142.png

 

3 Replies
brunobertels
Master
Master

hi 

see below for minichart since QS june 2020 : 

https://community.qlik.com/t5/Qlik-Design-Blog/Mini-Charts/ba-p/1726833 

for color look in the community or help for colormix and colormix1 function 

 

regards 

mpalha
Contributor III
Contributor III
Author

Hi @brunobertels ,

Thanks for the suggestion. I'm looking for a single bar. Do the mini charts in Qlik Sense allow for this? From what I've seen I need to add a dimension, but I am only looking for the share of a value within a single dimension.

brunobertels
Master
Master

Hi 

Well is this what you're looking for : 

brunobertels_0-1625734006722.png

if So , have a look to this post below made by @OmarBenSalem

https://community.qlik.com/t5/Documents/Creating-Mini-Chart-in-Qlik-Sense-tables/ta-p/1486234