# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor III

## 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!

1 Solution

Accepted Solutions
Partner

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:

7 Replies
Partner

Hi.

Use the Simple KPI extension.

Bye.

Contributor III
Author

is it possible to convert that to a table?

Partner

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

Partner

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

Partner

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

))…….)

Partner

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:

Contributor III
Author

thanks!

Tags
Community Browser