Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
Employee
Employee

Master Measure color in pivot table

Hi all,

I created a Master Measure with segment colors. I add the Master Measure to a chart and I correctly get it colored according to the segments I created. If I add the same Master Measure to a Table or Pivot it doesn't get colored...is this correct?

I'd like to avoid using a manual expression, as I already created the Master Measure color segments.

Thanks!

Alberto

5 Replies
Highlighted
shiveshsingh
Honored Contributor

Re: Master Measure color in pivot table

Do you have any sample?

Highlighted
Employee
Employee

Re: Master Measure color in pivot table

Look at the attached app: the barchart is correctly colored by measure inheriting the segment colors.

How can you achieve this in the Pivot Table? I have to manually write the expression...

Highlighted
shiveshsingh
Honored Contributor

Re: Master Measure color in pivot table

Got your concern, as far as I know, there isn't any option in pivot table like Bar chart. You can define the color codes in background color expression.

Highlighted
Employee
Employee

Re: Master Measure color in pivot table

Yeah, as I suspected. I'll use the expression then...

Highlighted
shiveshsingh
Honored Contributor

Re: Master Measure color in pivot table

All the best 🙂