Colour on Master measures

[JoseGarcia]

hi there,

I'd like to get master measures to pick up the colour from different dimension values on  a Gannt chart.

Formula for the colour settings is working ok. The issue is that both measures (duration and required date become affected). Colour should only affect on duration measure.

Is there any way round it?

I have added a picture that perhaps explains my issue.

[JordyWegman]

Hi Jose,

Can't you go to the color section of the extension/graph and give the color options a different type? This way you overrule the color from the master measure.

If you need some more help, please attach an QVF.

Jordy

Climber

[JoseGarcia]

@JordyWegman , thanks a million for your reply. 

The issue is that I only want colors to apply to one measure. 

When i use the expression option on the chart, it affects both measures and disrupts the gannt chart. 

I have attached QVF file. 

Look forward to your reply 🙂 

[JoseGarcia]

Jordy, 

do you have any suggestions to my color query?

🙂

saludos 
jose

[AshwinDaniel]

@JoseGarcia please check below link, This may help you. this looks similar to my earlier requirement. 

https://community.qlik.com/t5/App-Development/Colors-in-formula/m-p/1819153#M67154

[JoseGarcia]

@AshwinDaniel , thanks for the link. 
For some reason, colour properties does not offer dimension option. Only expression and measure. 

I think, this may not be possible on a gannt chart, because the colour affects both Gannt measures.

[JoseGarcia]

@AshwinDaniel, QVF is attached. I do not think there's a way around it 😞

[AshwinDaniel]

This is what I could see when I upload your App @JoseGarcia 

[JoseGarcia]

wow. ok. 
@AshwinDaniel , I have re-attached with data.

hope you are able to see visualizations