Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
bruno_m_santos
Partner - Creator
Partner - Creator

KPI Set Analysis issue

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

0 Replies