Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to Build KPI's in Qlikview?
Add a text box with an expression that calculates the result of your KPI.
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
Hello Ahmed,
can we include format in same expression showing M(millions),K(thousands)etc?
maybe helpful:
Re: Number format in espression
Re: how to enable the billion and trillian format
regards
Marco