Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
How to achieve Straight table With Inside Horizontal Bar Chart like a below image ?
Below is my currently developing of this chart.
Any ways to improve?
Please help.
Thank you!
Hi use this example:
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
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 ))
Hi use this example:
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
Thank you @JordyWegman @justISO for your great help. Much appreciated!!!