topic Re: Retrieve certain value in QlikView

Retrieve certain value

n1ef5ng1 — Thu, 25 Apr 2013 01:49:21 GMT

Hi,

I have multiple pivot table that display a certain value after doing some complex calculation.

I need to take a certain value from each table to form a new 'summary' table

is there any retrieve code or reference from this table coding to look into?

thank you

sujeetsingh — Thu, 25 Apr 2013 03:18:45 GMT

I did not get you.

n1ef5ng1 — Thu, 25 Apr 2013 03:42:36 GMT

I need to generate a table for the overview of KPI. Each value in the KPI have to derive using a complex formula

Therefore, I manage to retrieved these values using multiple pivot table.

Is it possible if I can take certain value from these multiple pivot table to form a KPI table?

n1ef5ng1 — Thu, 25 Apr 2013 05:46:17 GMT

A more detailed example

Desired Output

Indicator Score

A 70

B 70

C 85

D 33

For each indicator, it carries certain formula to dervie the score, I am currently using Valuelist to generate this table layout

I am able to derive the score by having multiple pivot table, each pivot table carries one score ( complex formula)

Therefore, how can i Compile all the score that is generated using multiple pivot table