Conditional Formatting in New Multi-KPI Visualization

[aarongroth]

I have using Qlik Sense for the last two years and was excited to see the addition of the Multi-KPI visualization.  I used the Qlik Branch version up until this point, but it didn't seem to play well with large data sets.  However, when I started to play with the new visualization, I was a bit perplexed by the fact that the label and value color settings are limited to a color picker instead of an expression input.

Does anyone know if there is a workaround to conditionally format the color of a label or value based on an expression in the new Multi-KPI visualization?  Any insight into if Qlik will expose the label and value color in a Multi-KPI measure to the expression editor?

Thanks and Best Regards.

[s_achraphe]

Hello

As I have the same issue  i "up" the topic

[LisaDrummond]

Same issue here, would like to use this instead of a 3rd party extension but I need conditional formatting to display my desired kpi. 

[s_achraphe]

 Nobody is able to answer

And I didn't find a solution as well

[tommyl]

Hello,

As far as i know there is no conditional formatting (like coloring values based on measures) option in Multi KPI extension if you are using only one measure. In case, you may use Simple KPI extension. You can vary -say- colors according to the measure - dimension value. 

Regards,

[Handel]

Hi,

At least in September 2019 version and forward you can add the measures as master items and set segment coloring there. Then switch "Conditional value color" on from measure option in the Data section of the object.

- Handel

[LisaDrummond]

Thank you, I'll have to check this out as currently I am just using Simple KPI instead - could not find another way to accomplish what I wanted.

[tommyl]

Hello,

I dont know your data but for multi kpi, try to change below css according to your data:

& .label {
font-family: 'Fredoka One';
font-size: 300%;
font-color:none;
border: none;
}

& .statistic-1 .value {
background-color: lightgreen;
font-family: 'Indie Flower', sans-serif;
color: red!important;
font-size: 300%;
border: none;
}

& .value {
background-color: lightblue;
font-family: 'Indie Flower', sans-serif;
font-size: 300%;
color: lightblue!important;
}

&.ng.binding{
color: #005EB8
}

css is under Appearance>Styles. As you created your data just copy above to your css field and modify accordingly.

What i sent is 2 valued multi KPI object's css among my projects. 

Regards,

[patricesalem]

@tommyl 

thanks for your tip, it works great...nevertheless, I'm trying to do as many users...apply your css type based on a condition.

Do you have an idea if this is feasible ?

if a measure > x% then apply this css style, if not, apply another css style ?

thanks

[tommyl]

Hello,

As far as i know, there is no conditionals in css. That extension only has css part and as far as i know, you cannot enter html or angular code over there. So, my answer is, as far as i know, no. I may be wrong-i wish. But if it is required i suggest to create extension or search for other extension options. 

Regards,