Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Build KPI's in Qlikview?

How to Build KPI's in Qlikview?

5 Replies
Chanty4u
MVP
MVP

Gysbert_Wassenaar

Add a text box with an expression that calculates the result of your KPI.


talk is cheap, supply exceeds demand
engishfaque
Specialist III
Specialist III

Dear Albert,

Key Performance Indicators (KPIs): KPIs show the past, present, and future target (or planned) values.


For example:

What are the business issues concern you? What are the necessary answers do you need?

Such as business user would like to watch out Sales for the year of 2015 (this is a KPI). So we need to make an expression which will return the desired result. For example you have Dashboard where Year and Sales are the fields. So Here is the way to calculate Sales for the year of 2015.


Expression in text object:

=Sum({<Year = {2015}>}Sales)

Kind regards,

Ishfaque Ahmed

Not applicable
Author

Hello Ahmed,

can we include  format in same expression showing M(millions),K(thousands)etc?