topic Re: adding automatically text in a kpi or object in Integration, Extension & APIs

adding automatically text in a kpi or object

LVTNP1 — Sat, 16 Nov 2024 19:11:08 GMT

Hello,

I need to insert a string from my database to a KPI (or an object), but I don't know the expression needed to answer this requirement.

Do anyone know how to do this ?

For example, I have on my database several rows containing : Name of project / comments / obstacles... and I want to visualise some informations without using a table. Is this possible ?

Thx for your help

Re: adding automatically text in a kpi or object

lorenzoconforti — Tue, 04 Feb 2020 12:25:01 GMT

Yes, it is possible; it depends on what you are trying to visualise and how. Can you describe an example of what you are trying to achieve?

Also, a sample data set in excel might help understand the issue

Re: adding automatically text in a kpi or object

LV — Tue, 04 Feb 2020 13:36:01 GMT

Thanks for your reply,

I have on my Excel sheet a table containing these kind of informations :

And I want to visualise in Qlik Sense these data like this :

So,do I have to create a table (or P&L table) to visualise these informations (the data file can contain a variable number of rows) or can I process differently to get this same template in Qlik Sense ?

Moreover (it's additionnal), can I put automatically a gauge next to each row in order to indicate the progress of these projects, knowing that there is a variable number of rows ?

Thank you

Re: adding automatically text in a kpi or object

lorenzoconforti — Tue, 04 Feb 2020 13:40:21 GMT

Apart from the gauge, you don't want to use a regular table? the looks and feel will be different but the content the same

I'm just trying to understand the challenge

Re: adding automatically text in a kpi or object

LV — Tue, 04 Feb 2020 13:54:02 GMT

If it was up to me, I would use a P&L table, but the requirements are from the executive management, so I am looking for a different way to achieve these needs. So, I will use a P&L table if it is not possible.

Do anyone have a solution to insert gauges automatically next to each rows ?

Thx for all your replies