
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to Build KPI's in Qlikview?
How to Build KPI's in Qlikview?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add a text box with an expression that calculates the result of your KPI.
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Ahmed,
can we include format in same expression showing M(millions),K(thousands)etc?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
maybe helpful:
Re: Number format in espression
Re: how to enable the billion and trillian format
regards
Marco
