Create Metrics Board

[balanandam]

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!

[Peter_Cammaert]

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

[balanandam]

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!

[Sergey_Shuklin]

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

[Peter_Cammaert]

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