Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.