Comparing indicators with Multi KPI Goal: compare current year with previous year sales in same KPI. See image below.In load editor add script:sales:
...
Show More
Comparing indicators with Multi KPI
Goal: compare current year with previous year sales in same KPI. See image below.![000.png 000.png](https://community.qlik.com/t5/image/serverpage/image-id/17122iE36CC039A2BC7937/image-size/large?v=v2&px=999)
In load editor add script:
sales:
load * inline [
year, sale,
2017, 50198,
2018, 61532,
2019, 63182
];
1) Add Multi KPI object (extension Qlik Sense)
![001.png 001.png](https://community.qlik.com/t5/image/serverpage/image-id/17121i3FF9BC00E6399696/image-size/large?v=v2&px=999)
2) Add a dimension
=ValueList('Current year', 'All')
![002.png 002.png](https://community.qlik.com/t5/image/serverpage/image-id/17120i4BB89D934C38935E/image-size/large?v=v2&px=999)
3) Add variables
![003.png 003.png](https://community.qlik.com/t5/image/serverpage/image-id/17119iCC50207E03923F1C/image-size/large?v=v2&px=999)
![004.png 004.png](https://community.qlik.com/t5/image/serverpage/image-id/17123i2A549601FD5D783F/image-size/large?v=v2&px=999)
4) Configure KPI appearance
![005.png 005.png](https://community.qlik.com/t5/image/serverpage/image-id/17125i048DB7463B19D83E/image-size/large?v=v2&px=999)
Properties Appearance > Dimensions
- Hide labels: true
- Center aligned labels: true
- Hide external borders: true
- Hide internal borders: true
5) Add a measure Current Year Sales
![006.png 006.png](https://community.qlik.com/t5/image/serverpage/image-id/17124i562C74A86C3F7241/image-size/large?v=v2&px=999)
Properties:
- Expression: =sum({<year={"$(vCurrentYear)"}>} sale)
- Label: ='Sales $(vCurrentYear)'
- Number formatting: Money
- Group by dimension: true
- Dimension Value: Current year
![007.png 007.png](https://community.qlik.com/t5/image/serverpage/image-id/17126iB1077A93BDB57484/image-size/large?v=v2&px=999)
- Icon: ='lui-icon lui-icon--line-chart'
- Icon size: Large
6) Add a measure Previous Year Sales
Properties:
- Expression: =sum({<year={"$(vPreviousYear)"}>} sale)
- Label: ='from $(vPreviousYear)'
- Number formatting: Money
- Label color: #7b7a78
- Value color: #7b7a78
- Group by dimension: true
- Dimension Value: Current year
- Override parameters: true
- Size: Tiny
- Labels order: Value, Label
![008.png 008.png](https://community.qlik.com/t5/image/serverpage/image-id/17127i793FA7B2541762DA/image-size/large?v=v2&px=999)
7) Add a measure Current Year vs Previous Year Percentage
Properties:
- Expression: =(sum({<year={"$(vCurrentYear)"}>}sale)/sum({<year={"$(vPreviousYear)"}>}sale))-1
- Number formatting: Number (12,34%)
- Label color: #7b7a78
- Value color: #7b7a78
- Hide label: true
- Group by dimension: true
- Dimension Value: Current year
- Override parameters: true
- Icon: =if((Sum({<year={"$(vCurrentYear)"}>}sale)/Sum({<year={"$(vPreviousYear)"}>}sale))-1>0,'lui-icon lui-icon--triangle-top','lui-icon lui-icon--triangle-bottom')
- Icon position: Value
- Icon order: Value, Icon
![009.png 009.png](https://community.qlik.com/t5/image/serverpage/image-id/17128iD0A7A4A2FFBF347F/image-size/large?v=v2&px=999)
8 ) Add a measure All sales
Properties:
- Expression: =sum(sale)
- Label: All
- Number formatting: Money
- Group by dimension: true
- Icon: ='lui-icon lui-icon--sheet'
- Icon size: Large
9) Add a measure Annual average
Properties:
- Expression: =sum(sale)/count(distinct year)
- Label: annual average
- Number formatting: Money
- Label color: #7b7a78
- Value color: #7b7a78
- Group by dimension: true
- Override parameters: true
- Size: Tiny
- Labels order: Value, Label
Done!
Best regards,
Ezir
Show Less