Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to Build KPI's in Qlikview?

How to Build KPI's in Qlikview?

5 Replies
Chanty4u
Esteemed Contributor III

Re: How to Build KPI's in Qlikview?

MVP & Luminary
MVP & Luminary

Re: How to Build KPI's in Qlikview?

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


talk is cheap, supply exceeds demand
engishfaque
Valued Contributor III

Re: How to Build KPI's in Qlikview?

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

Re: How to Build KPI's in Qlikview?

Hello Ahmed,

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

Re: How to Build KPI's in Qlikview?