topic Re: Table chart with progress bar in App Development

Table chart with progress bar

ena1309 — Mon, 13 Jun 2022 01:55:02 GMT

Hey peoplee,

I am wondering is it possible to add some kind of more detailed x-axis in Qlik table, something easier for user to follow the numbers and values.
More easy to understand my question: is it possible and how to add this red thing I draw at the picture 🙂 ?
(this is Qlik table chart)

Thankkk you in advance!

Re: Table chart with progress bar

vinieme12 — Mon, 13 Jun 2022 04:11:54 GMT

you can add a new column like below

=repeat('▉',ceil((Sum(sales)/Sum(total sales))*20))

Re: Table chart with progress bar

ena1309 — Mon, 13 Jun 2022 06:59:48 GMT

Thank you, that is cool idea for some occasions, but this time i want it to be like this visualization in Tableau (see below number sections)

Re: Table chart with progress bar

VishalWaghole — Mon, 13 Jun 2022 07:18:10 GMT

Hi,

Please find attached image from Qlik sense,

To achieve this, you need to select Labels and title from X-axis property, you will get it from below path,

Presentation-> x axis -> Labels and title.

Regards,

Vishal

Re: Table chart with progress bar

vinieme12 — Mon, 13 Jun 2022 07:56:57 GMT

Unfortunately we don't have anything like this in QlikSense yet, but you may submit a feature request for Qlik to hopefully add this in future releases

https://community.qlik.com/t5/Knowledge/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1712581

This is what I tried, kind of a hack! I won't recommend using this because

you need to define static steps
and the gaps need to be taken care of manually which can be off at times and can be misleading

but just sharing anyways

=IF(ROWNO()=0,concat( distinct '|' &valueloop(0,ceil(MAX(TOTAL AGGR(Sum(val),Cat)),100),250) /1000 ,'k........'), repeat('▉',ceil((Sum(val)/MAX(TOTAL AGGR(Sum(val),Cat)))*20)) )

Re: Table chart with progress bar

ena1309 — Mon, 13 Jun 2022 08:50:50 GMT

This is for bar chart, i need this for TABLE Chart 🙂
Thx anywayy

Re: Table chart with progress bar

eddie_wagt — Tue, 14 Jun 2022 14:03:53 GMT

Hello @ena1309 ,

I know you marked this one as solved and I am glad that @vinieme12 came to the rescue. However, I was reading this post yesterday and I couldn't get my mind of it. I really wanted to know what your example represents, or what you are exactly you are trying to achieve. The why behind this problem. In Qlik there is an obvious choice to use a bar chart with reference lines that you could use for visualizing the progress. But you really wanted a table, so I wonder why...

Unfortunately there is no option for adding a minichart with your requirement. See also this post/answer by @Dalton_Ruer . https://community.qlik.com/t5/New-to-Qlik-Sense/Horizontal-bar-in-table/td-p/1804814

I came up with a solution (and thanks for the inspiration @vinieme12 ) in a pivot table. This requires that the data must be prepared within the load editor though. See screenshot.

Have a nice day,

Regards Eddie

Re: Table chart with progress bar

ena1309 — Tue, 14 Jun 2022 14:58:52 GMT

Heyy Eddie,

Love your contribution every time! 🙂

Well, I am doing some recreation of Tableau dashboards to Qlik, so idea is that they have to be as similar as possible. In this particular case I have multiple columns/dimensions and that's why U need it to be table, instead of bar chart. (see the picture: it has three columns first, and then the measure)
Check the printsrceen from Tableau(so you could see what was the idea i will just scramble the values because of the data sensitivity) :
So in Tableau it is more easy for human eye to follow these mini bars, and I wanted that effect in Qlik 😄
Anyway thankkkk you

Re: Table chart with progress bar

eddie_wagt — Wed, 15 Jun 2022 11:00:43 GMT

Hello @ena1309 ,

Thanks for your compliment and also thanks for the reply.

I first thought you would like to segment the data, but you are looking for a table with a scale. Hmmm, that should be possible, but also with some 'hacks' I think. The question that still remains, how do you keep such a table readable for a user? Are they filtering for the dimensions they need? Or are they comparing the data like what is 'this part' doing compared to 'other parts'? If the use case is something that could be generic for all Qlikkies or users, than I would suggest to post this as an idea in the idea section here .

In the meantime I will think about a 'solution' to solve this.

Regards

Eddie