topic Re: Qlik Sense Simple Heatmap in Table in App Development

Qlik Sense Simple Heatmap in Table

Anonymous — Mon, 31 Oct 2016 16:02:29 GMT

I am trying to create the effect that is easily done in Excel below in a table in Qlik Sense.

Any help is appreciated.

Thank you,

- dave

Re: Qlik Sense Simple Heatmap in Table

rittermd — Mon, 31 Oct 2016 16:37:15 GMT

Hard to answer without knowing what your colors are based on.

In QS you can build an expression to control the background color and text colors in each cell. You go to edit mode and then expand the dimension or measure properties and add an expression for the colors.

But I would really need a better idea of what you are doing to give you any better answer than that.

Re: Qlik Sense Simple Heatmap in Table

Anonymous — Mon, 31 Oct 2016 19:23:29 GMT

Thanks for the help Mark. I guess I am taking for granted that this is an "easy" thing to do in other programs like Excel, Google DataStudio, etc ..

I followed the post below and created three variables which I then used in a background color expression. Very cumbersome process to get what I feel is a simple results.

Qlik Sense Color Range Theme Approach

Re: Qlik Sense Simple Heatmap in Table

berndjaegle — Fri, 10 May 2019 10:30:41 GMT

I took a very simple apporach:

=RGB(255,
255-(<your_kpi>),
255-(<your_kpi>)
)