topic Re: Straight table calcuations in QlikView

Straight table calcuations

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

My data tables are below.

KPI Data table:

The data table has KPIs data by area for each day.

KPI Medata Data:

Metadata table contains information such has KPI name, definition, category and targets.

I am trying to create straight tables that summarizes the KPIs by monthly or quarterly, based on the user selecting the periods from the list boxes.

Straight tables:

I am trying to create straight tables that summarises the KPIs. I have managed to create the below without any issues. Works fine with the filters.

I am struck in creating the next summary table, which tells the number of KPIs met in each category. I created 2 variables (vKPI = sum(Numerator)/Denominator ; vKPImet = if(vKPI >= Target,1,0) )

And then I tried to use the variable vKPImet in the staright table, but I am not getting the desired results.

Please can you share your thoughts and help me to solve this.

Re: Straight table calcuations

Anil_Babu_Samineni — Mon, 20 Feb 2017 01:50:51 GMT

What was the expected result. Would you provide sample to work on it same

Re: Straight table calcuations

Mon, 20 Feb 2017 02:06:14 GMT

Can You Tell me what is your expected output here

Re: Straight table calcuations

muthukumar77 — Mon, 20 Feb 2017 06:52:54 GMT

Hi,

Can you send me the sample app and expected output?

Re: Straight table calcuations

ramasaisaksoft — Mon, 20 Feb 2017 06:59:53 GMT

Hi,

There are only 3 rows for for KPI Category as (Customer Experience) but you gave the values as (KPI's Met 4 KPI's Not Met 2) so i am unable to understand what you are expecting?

please explain your expected output.

Re: Straight table calcuations

Anonymous — Mon, 20 Feb 2017 07:33:22 GMT

Hi all,

Thanks for you replies. Apologies for not providing enough details. I am trying to count the number of KPIs that met Target in each KPI category and each area. I will post the expected results shortly.

Thank you