Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikproject
Contributor
Contributor

Set Colours on a chart by Dimensions (Qlik Sense)

Hello for everybody! 

I have a question  I wonder if anyone could help me with it:

 

I have a table like this :

qlikproject_1-1666018208389.png

 

where as you can see I have defined in Qlik Sense chart only 1 Dimension ("Year" ) and 4 Mesarures defined .

I post simples measures just as example. 

I would like to make a chart where I have the posibility to fix de colour of each Measure and I couldn´t.

Besides that I would like to set that each mesarures have diferent type of graphs .

Qlik Sense offer to set the colours by "Measure" (offer heat colours function of the Measure value) , by "Expresion" or   automatic colours (Unique colour or Multicolours).

I add here and excel to show.

Thanks for any suggestion could help me!

P.D. I tried with lines + Areas type or with combined graph and I couldn't

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Labels (3)
1 Solution

Accepted Solutions
qlikproject
Contributor
Contributor
Author

Thnaks Martw for your fast answer!

I m afraid I should try with master measures as you said!

 

By the other hand in relation with the type of chart, I would like that por instance one of the measures be a line (as "sum(A)" for instance) and the others bar or area type ...in order to have a chart as I post at the excel file added.

thanks !

 

View solution in original post

2 Replies
MartW
Partner - Specialist
Partner - Specialist

I think what you need is to create a master measure for this. then you can set the color and automatically the chart should use that color(if not then you can always change it in the settings).

MartW_0-1666037656787.png

 

for the second part of the question, you can use a bar chart. drag the object on to the sheet and then on the left side  add the fields

MartW_1-1666037836843.png

 

qlikproject
Contributor
Contributor
Author

Thnaks Martw for your fast answer!

I m afraid I should try with master measures as you said!

 

By the other hand in relation with the type of chart, I would like that por instance one of the measures be a line (as "sum(A)" for instance) and the others bar or area type ...in order to have a chart as I post at the excel file added.

thanks !