KPI's in a tabular format

[ishanbansal1204]

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??

[MK_QSL]

Use ValueList Function for that...

ValueList() – For those tricky situations

Use Case for ValueList Chart Function

Missing Manual - ValueLoop() & ValueList()

[barrym1975]

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