Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Straight Table

Hi All,

I am using a Straight table in qliksense. 

I have totally three dimesnions and One measure (Sum(Sales)). 

Now i wanted to know that how can I replace numbers with Gauge image ? is it possible to acheive this ? 

 

Thanks in Advance 

1 Reply
tm_burgers
Creator III
Creator III

From the September 2020 release onwards you can use Indicators in your chart, but these do not look like Gauges. The other option is to use the Trellis Container with the Gauge as your master object... 

 

You could recreate something like a line guage with some variation of the below formula that I use for star ratings, but you could swap it for other Unicode symbols.

 

repeat('★',floor((column(1)/column(2))*5))&repeat('☆',5-floor((column(1)/column(2))*5)) 

 results in ★★★☆☆ 

 

But you could create an indicator gauge that looked like :

█ 80

███████ 40

Or, uncannily American like so:

█  ★  ████

██  ★  █████████