Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nikhilgarg
Contributor III

Prob regarding visualisation in QLikSense

Hello,

I have a situation where i need to color the rows of table as per the color in other chart. Pls. find my attached snapshot for more understanding.

In Mekko chart, as you can see states has a particular color. In the table next to it, i want the rows to be colored with same color as in Mekko chart. I cannt find a way to achieve this. Can anyone help me in this?

Thanks,

Nikhil garg

5 Replies
devarasu07
Honored Contributor II

Re: Prob regarding visualisation in QLikSense

Hi,

what is the issue here? u can simple write color conditional statement like below

simply write this expression in both your chart --> back ground color expression

if(State='AP' ,LightBlue(), if(State='COM',Yellow(),if(State='HR',Green(),if(State='HP',LightMagenta(), White()))))

// here u can add u r own custom color

Capture.JPG

nikhilgarg
Contributor III

Re: Prob regarding visualisation in QLikSense

HEy,

Problem is i am using Pivot table. ANd in pivot table, we dont have background color option in dimension

I cann't use straight table because, i ahve to dynamically name my measures as:

1: Sales' $(=Only(Year)-1) and this function will only evaluate in Pivot Table.

ANy other option?

fmarvnnt
Contributor

Re: Prob regarding visualisation in QLikSense

Try to follow the online help - starting from here - since it is possible Pivot table properties ‒ Qlik Sense

FM

(please tell us what solution you find)

nikhilgarg
Contributor III

Re: Prob regarding visualisation in QLikSense

In pivot table, i have looked the possibilites but not feasible. Can you let me know if in straight table we can make dynamic labels for measure?

fmarvnnt
Contributor

Re: Prob regarding visualisation in QLikSense

I think no since cells are not labels.

Community Browser