topic Re: KPI Example Dashboard in QlikView

KPI Example Dashboard

Tue, 17 Nov 2015 18:06:07 GMT

Hello newer to Qlikview and really liked the KPI example dashboard in QV11. Anybody have any clues how to recreate that? It looks like 4 linked objects together with different metrics and then a bar chart that changes with the selected metric. The first object is this at the end of its expression..> qmem://<bundled>/BuiltIn/led_r.png',

Anybody try to build something similar?

Re: KPI Example Dashboard

rwunderlich — Tue, 17 Nov 2015 18:58:36 GMT

What's the name of the QVW you are looking at, and which specific chart? Can you open the chart properties to see how it's done?

-Rob

Re: KPI Example Dashboard

Tue, 17 Nov 2015 19:42:34 GMT

Thanks.. It is the Executive Dashboard.qvw in the QVW examples. The tab is KPI. Yes I can see how they did some of the expressions but I'm not sure how they are linked and what they did with the bar charts.

Re: KPI Example Dashboard

Tue, 17 Nov 2015 19:43:37 GMT

I also cannot get the traffic light to work like it does in this dashboard!

Re: KPI Example Dashboard

rwunderlich — Tue, 17 Nov 2015 22:56:01 GMT

FIrst, make yourself a copy of the Executive Dashboard to work on.

Each row of the Straight Table is covered by a separate transparent Text Object. The Action associated with the Text Object is Set variable vShowChart to 1,2,3,etc value. The bar charts are individual charts with a Show Condition of vShowChart=n. Click a row in the table and you are clicking the Text Object which sets the variable and you see the associated bar chart.

If you move the Text Object "buttons" out of the way you can get at the underlying chart properties easier. Objects are currently locked, so:

Ctrl-a to select everything.

Select Properties, Layout, Allow move/size.

The KPI table is a single chart with [Dashboard Metric] as the Dimension, and a 3 expressions. The expression calculates a different number based on the [Dashboard Metric] value of the current row. The traffic light is a display representation type of image, and the same effect can be created with a display representation of gauge.

Maybe more than you asked for

On to your specific traffic light question. Can you post an example qvw of your problem?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: KPI Example Dashboard

engishfaque — Wed, 18 Nov 2015 05:27:31 GMT

Dear Jason,

Go to Expression section of your chart object and change your Display Options "Representation" from Text to Image or Traffic Light Guage.

Please note expression must be selected where you applied "qmem://<bundled>/BuiltIn/led_r.png". Then Apply and OK.

Kind regards,

Ishfaque Ahmed !