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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

Straight table With Inside Horizontal Bar Chart

Hi there,

How to achieve Straight table With Inside Horizontal Bar Chart like a below image ?

Purushothaman_0-1659492787536.png

Below is my currently developing of this chart. 

Purushothaman_1-1659493408428.png

 

Any ways to improve? 

Please help.

Thank you!

1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi use this example:

JordyWegman_0-1659508839607.png

This is the calculation. You can replace Sum Sales and the dimension with your example:

=Repeat('𝗹',round(sum(Sales)/max(total aggr(sum(Sales), CategoryName))*25))
& Repeat('⋅',25-round(sum(Sales)/max(total aggr(sum(Sales), CategoryName))*25))

Jordy

Climber

Work smarter, not harder

View solution in original post

3 Replies
justISO
Specialist
Specialist

Hi, maybe someone can correct me if I'm wrong, but as I know, it is impossible to do horizontal sparkline in qlik. But there are some workarounds, like creating separate measure (expression below) with witch and a little tweak its possible to achieve something similar as wanted:

repeat('▇', round(sum([Sell-Out Amt]) / sum(total [Sell-Out Amt])*10 ))

JordyWegman
Partner - Master
Partner - Master

Hi use this example:

JordyWegman_0-1659508839607.png

This is the calculation. You can replace Sum Sales and the dimension with your example:

=Repeat('𝗹',round(sum(Sales)/max(total aggr(sum(Sales), CategoryName))*25))
& Repeat('⋅',25-round(sum(Sales)/max(total aggr(sum(Sales), CategoryName))*25))

Jordy

Climber

Work smarter, not harder
Purushothaman
Partner - Creator III
Partner - Creator III
Author

Thank you @JordyWegman @justISO  for your great help. Much appreciated!!!