Stain cells randomly

[danielaw]

Hello!

I have Qlik Sense Enterprise and would like to highlight individual cells in tables and pivot tables. These cells don't have a specific value and change frequently, but they are very important to us. Unfortunately, this isn't possible in this version; I can only color entire rows or columns or set conditions. Is there an add-on that can do this?

Thanks

[Daniel_Castella]

Hi @danielaw 

As far as I know, the background and the text color in the cells can be changed individually if the proper expression is set in the chart.

However, I'm not sure if I'm understanding at 100% your issue. Could you, please, provide some examples in order I can check it better?

Kind Regards

Daniel

[danielaw]

Hello!

Sorry for the late reply—I was sick and everything piled up.

So, I currently have a table formatted like this. The goal is to achieve the formatting shown in the second image. I also want to randomly color a cell—not based on a threshold, but simply because I want to highlight that cell.

I'm using Qlik Sense Hub, and I can only color entire columns; I haven't found the option to color rows at all.

Is there an extension or add-on for this?

Thanks
Best regards

[Daniel_Castella]

Hi @danielaw  

In edit mode, for each column you have an option called Background color expression. There you can put all the formulas you want to alter the cell colors as you wish. For example, using the expression:

If(Gesamtwerte='Betrieb 5', RGB(255,255,0),

     If([Gesamt Offen] - [Noch nicht ffallig]<200000, RGB(255,0,0),

         If([Gesamt Offen] - [Noch nicht ffallig]<500000, RGB(0,0,255),

              RGB(0,255,0))))

I made the cell red if the value is under 200000, blue under 500000, green for the others, and yellow the one corresponding to Betrieb 5 to add some random as you said. The result:

If I would like to color the other columns for all the row to have the same colors, I just need to copy the formula and paste it in the other columns background color expression.

Let me know if this helps you or if further clarifications are needed.

Kind Regards

Daniel

[danielaw]

Hi!

Yes, thank you, that's a good starting point, I'll need to adapt it accordingly.

Do you perhaps have any ideas on how I can color the column headings while leaving the columns themselves uncolored?

[BIAKS]

You can do it with MultiKPI's CSS styles as shown below:

css

You can find the necessary ids (ejpSuQu and RpJcjYu) by adding /options/developer to your url:

devoptions

and right clicking your objects and selecting developer:

developer

you can change '#id-header-2' to '#id-header-[column number you want to color]'

you also need to add at least one measure to multiKPI object to make it work.

[danielaw]

Hello!

That's exactly my problem. I can't assign a specific value to "ohm" because it fluctuates from -100k to 1 million, and there are other cells with the same values. Therefore, I'm looking for an add-on that allows me to color these cells completely arbitrarily.

What I also can't find is a way to color only the row with the total values ​​in the pivot table...