Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Showing data

Hello,

I'd like to show the following data in a (like?) 3 columns-table:

A KPI description - A KPI Value - A KPI Note

B KPI description - B KPI Value - B KPI Note

C KPI description - C KPI Value - C KPI Note

All these values are stored in a different variable.

Would someone suggest to me then right object I can use to reach the goal?

Thks,

N.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

If you want to use a table object specifically then you can also look at ValueList() and ValueLoop() which allows you to create a custom dimension and use this to reference either expressions or variable holding the expressions. They are really handy functions so worth trying to understand.

View solution in original post

6 Replies
its_anandrjs

Hi,

You can do one of the ways

1. By the text objects use variables there like

=$(vAKPIDesc) and so on for all A variables then

=$(vBKPIDesc) and so on for all B variables then

=$(vCKPIDesc) and so on for all C variables then

Here you need 9 text objects.

2. By any straight chart same here use the variable in the chart

Hope this hepls

Anand

Anonymous
Not applicable
Author

Sorry...maybe I'm not very pratical using the straight tables...How can I set it to allow me to put 9 defined and different values in a 3x3 matrix?

Thks

its_anandrjs

Hi,

Create 9 text object is easy for you and keep it identical to each other i provide you simple shot for that.

Var.png

Note:- in the expression part use variable like start with equal sign and variable name =$(vAKPIDesc)

Regards,

Anand

Anonymous
Not applicable
Author

Right, I've simplified my example...to tell the truth I've got to show 7 kpi (thus 21 cells): if it should be possible to store them into an unique table I prefer this solution. 😉

Anonymous
Not applicable
Author

If you want to use a table object specifically then you can also look at ValueList() and ValueLoop() which allows you to create a custom dimension and use this to reference either expressions or variable holding the expressions. They are really handy functions so worth trying to understand.

Anonymous
Not applicable
Author

A great suggestion ValueLoop & ValueList

Thank you very much.

N.