topic Re: Conditional Formatting in New Multi-KPI Visualization in App Development

Conditional Formatting in New Multi-KPI Visualization

aarongroth — Mon, 20 Dec 2021 21:38:40 GMT

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.

Re: Conditional Formatting in New Multi-KPI Visualization

s_achraphe — Tue, 25 Jun 2019 12:43:38 GMT

Hello

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

Re: Conditional Formatting in New Multi-KPI Visualization

LisaDrummond — Tue, 27 Aug 2019 12:49:52 GMT

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

Re: Conditional Formatting in New Multi-KPI Visualization

s_achraphe — Tue, 27 Aug 2019 12:55:34 GMT

Nobody is able to answer

And I didn't find a solution as well

Re: Conditional Formatting in New Multi-KPI Visualization

tommyl — Fri, 13 Sep 2019 07:46:49 GMT

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,

Re: Conditional Formatting in New Multi-KPI Visualization

Handel — Thu, 12 Dec 2019 13:28:31 GMT

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

Re: Conditional Formatting in New Multi-KPI Visualization

LisaDrummond — Thu, 12 Dec 2019 13:32:03 GMT

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.

Re: Conditional Formatting in New Multi-KPI Visualization

tommyl — Thu, 26 Dec 2019 08:13:39 GMT

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,

Re: Conditional Formatting in New Multi-KPI Visualization

patricesalem — Tue, 11 Feb 2020 23:04:12 GMT

@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

Re: Conditional Formatting in New Multi-KPI Visualization

tommyl — Thu, 13 Feb 2020 11:55:01 GMT

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,