7 Replies Latest reply: Oct 17, 2018 3:37 AM by willem van der Plas

# calculations as dimension in KPI table

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!

• ###### Re: calculations as dimension in KPI table

Hi.

Use the Simple KPI extension.

Bye.

• ###### Re: calculations as dimension in KPI table

is it possible to convert that to a table?

• ###### Re: calculations as dimension in KPI table

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/SyntheticDimensionFuncti…

/Teis

• ###### Re: calculations as dimension in KPI table

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

• ###### Re: calculations as dimension in KPI table

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

))…….)

• ###### Re: calculations as dimension in KPI table

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:

• ###### Re: calculations as dimension in KPI table

thanks!