topic Re: kpi in QlikView

kpi

Wed, 04 Jun 2014 07:40:40 GMT

How to create a kpi in qlikview in tabulur form
like i have attached

Re: kpi

its_anandrjs — Wed, 04 Jun 2014 07:46:20 GMT

1. This is a straight table with KPI expressions individually and use of background color with conditionally.

2. Use of Images in the expression part with conditionally with up and down arrows.

Re: kpi

Wed, 04 Jun 2014 07:50:54 GMT

So what object should I chose I that because I want to give the row name manually,I am not pulling the row name from any table like for the first column I.e KPI I ll give the names of kpi manually then I ll do calculation of the other rows with the use of fields I am available with so could u please exaggerate a little bit

Re: kpi

Wed, 04 Jun 2014 07:50:59 GMT

Hello,

it looks, like each of your KPI's may has different expressions.

You may try to define island table with two fields KPI_name and KPI_nbr.

Then, in your chart use KPI_name as dimension.

As expression use: pick(KPI_nbr,expr_for_KPI1,expr_for_KPI2,.....)

Let me know if it helps.

regards

Darek