Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

thomas_kuler
New Contributor III

KPIs question

Hi everyone!

Is it better to calculate KPIs from a script level and store KPIs in a fact table OR calculate KPIs inside UI using Set Analysis ?

1 Solution

Accepted Solutions
MVP
MVP

Re: KPIs question

KPI is an expression / formula used to calculate a value that usually change when the user click (filter)

IMHO better to define it in the user interface as an expression

Dimensions and Measures

2 Replies
jduarte12
Contributor II

Re: KPIs question

Hi.

Well, generically speaking, I would recommend to store KPIs in the script level - for example, in a qvd layer - and then use it when you load the script of your qvw dashboard.

Nevertheless, if the amount of data is not relevant, it should be fine using set analysis.

Best regards,

João Duarte

MVP
MVP

Re: KPIs question

KPI is an expression / formula used to calculate a value that usually change when the user click (filter)

IMHO better to define it in the user interface as an expression

Dimensions and Measures

Community Browser