Set Analysis on a variable calculation

Anonymous — Mon, 02 Jul 2018 11:37:47 GMT

Hi,

I have a data table as follows:

Month	KPI_ID	Num	Denom
01/04/2018	KPI_001	7	30
01/05/2018	KPI_001	18	45
01/04/2018	KPI_002	6	72
01/06/2018	KPI_002	9	54
etc...

I need to put this in a STRAIGHT table as I need to use mini charts to show a trend.

I need the KPI_ID down the side and also to put the Months across the top of the table so I need to use expressions to do this.

Some KPIs are calculated as SUM(Num)/SUM(Denom), some are just SUM(Num)...some are more complicated so I wanted to keep all of this logic within a variable (vFormula)

I was then going to put my expression as =Sum({<Month={"$(vFinYear_Apr)"}>}$(vFormula)) but I can't get it to work...any ideas?

If my variable is just Num (with no preceding 😃 then it does give the correct result for that, but anything more complex and it doesn't work.

swuehl

topic Set Analysis on a variable calculation in QlikView

Set Analysis on a variable calculation