KPI Set Analysis issue

bruno_m_santos — Mon, 08 Oct 2012 16:32:07 GMT

Hi,

I'm trying to create some KPI, at the level of the line, but first I'm testing at column. I've created an expression like :

=sum( {$ <MonthID = {$(=Max(MonthID))},

Date = {"<=$(=Max(Date))"},

Year = ,

Quarter = ,

Period = ,

= ,

Month = >*<numerolinhatot={"L005"}>}Amount

But I wanted the value of the line "L005" to replicate in all rows, but is only appearing for the line itself.

The ultimate goal is to create KPIs, the like (L005 + L006) / L007

Thanks in Advance

Bruno

topic KPI Set Analysis issue in QlikView