Pre-calculation

[#1]

Hello all,

I'd like to pre-calculate KPI's for each month in order to generate my charts more quickly. I'm just not sure how to do this fast.

I was thinking of creating an inline table and doing the calculation in the load. Something that looks like this:

LOAD

    KPI,

    $(=fn) as KPI_VALUE

INLINE [

KPI

1

2

3

4

5

];

Where fn would be the appropriate function.

But how do I refer to the other fields in my data model? If I would replace the fn by count(OTHER_FIELD) then I get an error...

[pablolabbe]

Blue,

  In a load script, it's not possible to refer to columns in other tables, like in chart expressions. You have to join the tables first, and after that, you can create calculations with these fields in the joined table.

  Probably you will have to create several blocks, each one calculating a KPI and after that concatenate all the resulting calculations in one single table.

Regards,

Pablo Labbe

Qlikview Consultant

Vision Gestão & Tecnologia

www.visiongi.com.br