topic Create Metrics Board in QlikView

Create Metrics Board

balanandam — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I wanted to prepare Metric Board like below in my app, I wants to know what is the best way for this.

this one I did by tweaking Guage Chart, but find difficulties to align text. And, text appears here will change as per user language selection ex: Transactions in English convers Actas in Spanish.

what I need is:

Devices :208

Workstations :41

Transactions :1329

using

=Only({<Index={23}>} [$(=vDataLanguage)]) &repeat(' ',20-len(Only({<Index={23}>} [$(=vDataLanguage)]) ))&' : '&WorkStation#

=Only({<Index={24}>} [$(=vDataLanguage)]) &repeat(' ',20-len(Only({<Index={24}>} [$(=vDataLanguage)]) ))&' : '&Total.Sessions

=Only({<Index={25}>} [$(=vDataLanguage)]) &repeat(' ',20-len(Only({<Index={25}>} [$(=vDataLanguage)]) ))&' : '&TotalDevices
Pls. suggest If I do need to re-write this formula or else suggest any best way

Thanks!

Re: Create Metrics Board

Peter_Cammaert — Fri, 06 Oct 2017 10:06:38 GMT

To display metrics like this, you don't really need charts. You can use simple text boxes.

Put the string in a text box to the left, and the corresponding measure in a text box to the right. Space them in such a way that the left text box is large enough to accept the longest string. Whatever the language.

It may be a bit more work, but the end result will be very nice.

For an example, visit the Qlik demo site and search for a document called Executive Dashboard. The measures in the grey area on the first sheet are all formatted like this.

Best,

Peter

Re: Create Metrics Board

balanandam — Mon, 09 Oct 2017 05:22:27 GMT

Hi Peter,

I should be able to move this dashboard any where in the report without much effort. But, if create text box for teach metric, I can't move entire Metric in a single go rt ? I have to be move each single text object and rearrange.

Thanks!

Re: Create Metrics Board

Sergey_Shuklin — Mon, 09 Oct 2017 06:13:31 GMT

Hello!

You don't have to use multiple text boxes (especially if you use one text format for output string).

You can create one textbox with expression like this:

='Metric1: '& sum(metric1) & chr(13)

'Metric2: '& sum(metric2) & chr(13)

'Metric3: '& sum(metric3) & chr(13)

and so on

P.S.: chr(13) it's a carriage return

Re: Create Metrics Board

Peter_Cammaert — Mon, 09 Oct 2017 07:40:48 GMT

Indeed. The object grouping/ungrouping feature is still missing in QlikView.

An alternative that lets you easily/automatically align texts and metrics and at the same time offers you single-click movement and repositioning is to use a straight table. How to do this?

Create a new straight table
Either add a single dummy dimension (like ='Metric') or leave the dimensions blank.
Add an expression for every metric. Disable Show totals.
In Properties->Presentation, enable the 'Horizontal' checkbox. Your table will now be rotated 90deg. Columns become rows and vice versa.
Remove all chrome, colors and lines from the straight table layout that you don't need. If you do this thoroughly, you can get a textbox look like you posted in your OP.

The font face, size and other properties aren't really important now. Just the alignment options in the PResentation tab.

Best,

Peter