topic Re: KPI's in a tabular format in QlikView

KPI's in a tabular format

ishanbansal1204 — Sat, 24 Dec 2016 08:52:44 GMT

Hi Experts,

I have created multiple kpi's. But the problem.now is that I have to place them in a tabular format.

Example.

I have customers and the different measure for that is week , WOW, YTD

I have created individual KPI for that but now the look and feel of this is very bad. Is there any tabular structure where I can place my koi??

Re: KPI's in a tabular format

MK_QSL — Sat, 24 Dec 2016 09:43:25 GMT

Use ValueList Function for that...

ValueList() – For those tricky situations

Use Case for ValueList Chart Function

Missing Manual - ValueLoop() & ValueList()

Re: KPI's in a tabular format

barrym1975 — Mon, 02 Jan 2017 18:02:33 GMT

Hi Ishan,

Yes, you can make a little inline table that lists the name and order of each of your KPIs and create a variable to hold the formula for each KPI. Then create a straight table with the KPI name field as the dimension and an expression that picks the correct KPI, e.g., pick(KPINum, $(vKPI1),$(vKPI2),$(vKPI3),... ).

I'm attaching a sample QlikView.

Regards,

Barry