Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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