Line Plot for several KPIs

vrodr188 — Mon, 29 Nov 2021 18:52:45 GMT

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)

Re: Line Plot for several KPIs

MarcoWedel — Mon, 29 Nov 2021 19:26:23 GMT

Dimension:

ValueLoop(1,5)

Expression:

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

hope this helps

Marco

Re: Line Plot for several KPIs

vrodr188 — Tue, 30 Nov 2021 22:01:35 GMT

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

topic Re: Line Plot for several KPIs in QlikView

Line Plot for several KPIs

Re: Line Plot for several KPIs

Re: Line Plot for several KPIs