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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Woppi
Contributor II
Contributor II

Multi KPI colour measure with formula

Hi, I use Multi KPI an I want to colour the measure by formula.

For example :If 'OSR MTD vs. Forecast Base Case MTD > 0, red(), green()

It doesn't work:(

This is my measure by formula:

Sum(
{<
REVENUE_FORECAST_TYPE ={'OSR_IST'},
Date_FORECAST_THISYEAR_FLAG = {1},
Date_FORECAST_ACTUALMONTH_FLAG = {1}
>}
REVENUE_FORECAST)

-

Sum(
{<
REVENUE_FORECAST_TYPE ={'BASE_CASE', 'GRUNDRAUSCHEN'},
Date_FORECAST_THISYEAR_FLAG = {1},
Date_FORECAST_ACTUALMONTH_FLAG = {1}
>}
REVENUE_FORECAST)

Woppi_0-1674210797866.png

 

Labels (2)
1 Reply
mato32188
Specialist
Specialist

Hi @Woppi ,

I think color by expression is not supported in Multi KPI object. I suggest you to use other one.

br

m

ECG line chart is the most important visualization in your life.