Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 !