calculations as dimension in KPI table

[thewillemzelluf]

Hello everyone,

I have a question about a KPI table. I want to use different KPIs (which are calculations in qlik editor) as a dimension for a KPI table. (see the appendix as an example).

However, I have no idea how to cast a calculation into a dimension so that, for example, I specify all calculations as a dimension under the name 'KPI'.

Someone any idea how this can be done? Thanks in advance!

[christian77]

Hi.

Use the Simple KPI extension.

Bye.

[thewillemzelluf]

is it possible to convert that to a table?

[teiswamsler]

hi Willem

It can be done with the ValueList() function as a dimension.

See Qlik help for a exsample

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Synt...

/Teis

[christian77]

Use a table then. Any artificial dimension will be fine.

[christian77]

For the table.

Load a field (FAKE DIM) with values A, B, ……. N

Place that dimension in the dimension place.

Then go to measures and write:

IF([FAKE DIM]='A', first KPI,

IF([FAKE DIM]='B', secondKPI,

………..

IF([FAKE DIM]='N', Nth KPI

))…….)

[OmarBenSalem · Accepted solution]

Do sthing like this:

As a dimension in ur table use :

valuelist('Kpi1',Kpi2')

as a measure:

if( valuelist('Kpi1',Kpi2')='Kpi1', MeasureofKpi1,MeasureOfKpi2)

Example:

[thewillemzelluf]

thanks!