Performance Monitoring in Hospitals BThe UKBB relies on data-driven hospital management using a management information system (MIS) based on Qlik Sense and SAP.
More efficiency and structure The JURA Materials Group uses iVIEW to implement an efficient ETL link between SAP FICO and Qlik
Performance Monitoring in Hospitals BThe UKBB relies on data-driven hospital management using a management information system (MIS) based on Qlik Sense and SAP.
More efficiency and structure The JURA Materials Group uses iVIEW to implement an efficient ETL link between SAP FICO and Qlik
Implementing simple KPI Visualisations Published on 09.06.2017 News BI-Blog The impact of an effective dashboard design to clearly communicate key information to users and better highlight comparisons and trends. Implementing simple reusable KPI boxes is one way to show different KPI's on a dashboard or cockpit. These would look like: We can clearly see the current situation, with some additional informations about previous year or comparison to the budget. All this can done by using textboxes and some codes. Within the QlikView application put the code below in the script editor: SET PerformanceSymbol = if($1 < $2, chr(9660),if($1 > $2, chr(9650), chr(9654))); SET PerformanceColor = if($1 < $2, red(),if($1 > $2, green(), black())); In this example I have used Sales and Budget values. I have created two textboxes showing once the Sales and once the Budget: ='Sales: '&num( (sum(LineSalesAmount)),'###'&ThousandSep&'##0') ='Prev. Year: '&num( (sum({ < Year={2014}> }LineSalesAmount)),'###'&ThousandSep&'##0') Now, I have created a third one, including the difference: =num( (sum(LineSalesAmount)-sum({ < Year={2014}>}LineSalesAmount))/ sum({ < Year={2014}>}LineSalesAmount) , '#'&ThousandSep&'###'&DecimalSep&'## %') & $(PerformanceSymbol($(=sum(LineSalesAmount)), $(=sum({ < Year={2014}>}LineSalesAmount)))) In the Fonts register, for color I put this expression for calculating the color: $(PerformanceColor($(=sum(LineSalesAmount)), $(=sum({ < Year={2014}>}LineSalesAmount)))) And the result shows me the difference in percent and because my Sales are higher then my budget, the colors appear in green. Arranging them all, I have then a KPI box, which I also can reuse to compare with previous year or for other KPIs. Oktay Pamuk +41 61 826 80 80 pao@informatec.com vCard Email Facebook Instagram LinkedIn Twitter Xing Leave a comment Your name Titel E-Mail-Adresse Kommentar About text formats Plain text No HTML tags allowed. Lines and paragraphs break automatically. Web page addresses and email addresses turn into links automatically. Tags QlikView KPI Qlik Visualisation Dashboard Back to Newsroom