Line Plot for several KPIs

[vrodr188]

Intro:

The customer request is to create a line chart that shows 5 different KPIs. Each KPIs has a 3-4 is statement inside and they are basically counting the number of rows (key id) that comply with the different conditions. 

I was able to create a bar chart with a fake dimension and 5 expressions (giving me 5 bars).  But the specific request is to have a line chart. 

My previous experience is in python and there I will probably put the KPIs in a data-frame with 2 columns (kpi_name, kpi_value) and plot that as a line chart. 

Questions:

1. I am wondering if I can do something similar to what I can do in python but in QlikView?

2. A coworker suggested looking into calculated dimensions. I was able to create one of the KPIs as calculated dimensions. But I do not know how to concatenate the 5 KPIs in one dimension. my expression here will probably be count(key id)

 

[MarcoWedel · Accepted solution]

Dimension:

ValueLoop(1,5)

Expression: 

Pick(ValueLoop(1,5),
     KPI_Expression1,
     KPI_Expression2,
     KPI_Expression3,
     KPI_Expression4,
     KPI_Expression5
     )

hope this helps

Marco

[vrodr188]

Thank you very much for the help. It worked seamlessly!