Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Use ValueList Function for that...
ValueList() – For those tricky situations
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