Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello for everybody!
I have a question I wonder if anyone could help me with it:
I have a table like this :
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
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 !
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).
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
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 !