topic Re: Qlik Sense-Set up a color in a table in App Development

Qlik Sense-Set up a color in a table

Wed, 27 Jan 2016 09:31:21 GMT

Hi there,

I have been trying to find out a way to use any background or font color in a pivot table. However, I'd like to use it inside the part of dimensios. For instance, I have my dimensions column and inside it 3 different levels so what I'd like to do is to setup up a different color (background or font one) to each of the level parts of the dimensions. Is it possible to do so in QlikSense?

I atttach a photo to clarify more the issue in case of doubt.

Thanks so much for your help!!!!

Regards,

Ainhoa

Re: Qlik Sense-Set up a color in a table

Chanty4u — Wed, 27 Jan 2016 11:04:18 GMT

chk dis

How to conditionally colour a pivot table in Qlik Sense?

Re: Qlik Sense-Set up a color in a table

Wed, 27 Jan 2016 11:40:27 GMT

I've had a look to your link but in my case I feel it is not useful as what I tend to do is assign a font to a particular field (as said below, different levels within a same dimension).

For example:

I have a dimension which is "brands" in a pivot table. And within brands I have coke, Pepsi, whatever and what I'd like to do is to set up a different color to each of them independently of profit and other values in the table. E.g coke= red (color), Pepsi= blue...and so on and so forth.

Re: Qlik Sense-Set up a color in a table

undergrinder — Wed, 27 Jan 2016 12:40:28 GMT

Hi Ainhoa,

As far as I know you can set color only to measurements.

Re: Qlik Sense-Set up a color in a table

reddy-s — Wed, 27 Jan 2016 19:56:22 GMT

hi Ainhao,

Conditional colouring cannot be set for the dimensions as of now as Undergrinder mentioned. Its only possible with the measures. But you will have to go with an extension to achieve it.

Thanks,

Sangram.

Re: Qlik Sense-Set up a color in a table

Thu, 28 Jan 2016 08:35:03 GMT

Thanks both for your help. I thought last versions of QlikSense could have implemented that feature.

Re: Qlik Sense-Set up a color in a table

reddy-s — Thu, 28 Jan 2016 23:33:19 GMT

Hopefully we will have it in the next version.

Thanks,

Sangram

Re: Qlik Sense-Set up a color in a table

Fri, 29 Jan 2016 07:10:43 GMT

Thanks for your help. And as you said before I would have to go with an extension to achieve so. Do you know any that could help me meanwhile?

Re: Qlik Sense-Set up a color in a table

reddy-s — Fri, 29 Jan 2016 14:00:02 GMT

Hi Ainhao,

Check the Qlik Branch for extesnsions. Let me know if you need any help in building one.

Thanks,

Sangram

Re: Qlik Sense-Set up a color in a table

thierrytt1102 — Thu, 04 Feb 2016 10:05:33 GMT

Hi Sangram,

That's also really blocking for me. I'm used to make some pnl with a pivot table but, as mentioned, I cannot make the column coloured. I found the PnlSmart extension but it's working like a straight table, not pivot.

Do you think I have to create an extension (but I'm not technical) or wait for the next version of Sense?

Thx

Re: Qlik Sense-Set up a color in a table

reddy-s — Fri, 05 Feb 2016 10:15:26 GMT

Hi Thierrytt,

You will be needing HTML,CSS, Javascript and jQuery to build an extension and I am sure it wont be that difficult if you already are familiar with programming. So if you willing to learn go with an extension.

Also, the next release of Qliksense is not far off. So lets hope for the best.

Thanks,

Sangram.