Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Aug 15, 2019 11:40:44 AM
Aug 15, 2019 11:40:44 AM
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:
load * inline [
year, sale,
2017, 50198,
2018, 61532,
2019, 63182
];
1) Add Multi KPI object (extension Qlik Sense)
2) Add a dimension
=ValueList('Current year', 'All')
3) Add variables
4) Configure KPI appearance
Properties Appearance > Dimensions
5) Add a measure Current Year Sales
Properties:
6) Add a measure Previous Year Sales
Properties:
7) Add a measure Current Year vs Previous Year Percentage
Properties:
8 ) Add a measure All sales
Properties:
9) Add a measure Annual average
Properties:
Done!
Best regards,
Ezir
Hello,
When we add year as a filter and selecting the values are not reflecting.What to do?
Bom dia estou usando o multi KPI porem ele agora desconfigurou tudo conforme a imagem abaixo
Good morning, i am work with multi KPI but now nor working, print below.
What can i do?