Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
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