Qlik Community

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 
Search instead for 
Did you mean: 
thewillemzelluf
Contributor III
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).KPI.png


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
OmarBenSalem
Partner
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:

Capture.PNG

View solution in original post

7 Replies
christian77
Partner
Partner

Hi.

Use the Simple KPI extension.

Bye.

thewillemzelluf
Contributor III
Contributor III
Author

is it possible to convert that to a table?

teiswamsler
Partner
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

christian77
Partner
Partner

Captura.JPG

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

christian77
Partner
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

))…….)

OmarBenSalem
Partner
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:

Capture.PNG

View solution in original post

thewillemzelluf
Contributor III
Contributor III
Author

thanks!