Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
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)
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?
I think no since cells are not labels.