Customize colors and data

[JuanMu]

Hi All,

I need your help to solve two issues, I would like to show the same data in two different graphics. The same graphics contains the real values but the wrong colours and the second graphics has the correct colours but the wrong data.
Please could you help me. How can I deffine colours in the first graphics, the data are created with a master items.
In the second graphic I can show the corrects colours but I don't know how show the real values, the value "20" it's an example.

Best regards,
Juan Muñoz.

[eliran]

Hi Juan,

I'm not really sure what you did in your app.

All the master items (expressions0 you created will result in the value of 20, I'm not quite sure what you wanted to achieve.

As for the dimension, please see attached, You need to edit the dimension in the master items, and go for value colors, and there you can define a default for each of the values.

By the way, it's not best practice to have a calculated dimension.

If you can elaborate more on the need in the second graph, I might help you as well.

Regards,

Eliran.

[JuanMu]

Hi Eliran,
Many thanks by your help, I'm very noob with the Qlik Sense program and I had not see the value options color in the dimension 😞
For the secon graph I would like to represent the same values that the first graph automatly, but since I don't know how to do it, I seleted all the values to the same value 20, I can select the value to 287, 34, 31, 26, 12, 5 manualy, but the question is How can I add the formule for to aumaticaly calculate the values in the second graph?.

Best regards,

Juan Muñoz.

[eliran · Accepted solution]

Hi Juan,

It's okay, we all start from somewhere.

As for the second graph, just copy paste the pie chart, and convert it to bar chart.

You don't need to add specific measure for each of them, it does that automaticaly.

If for some reason, you need these expressions as seprate calculations, you can use the following for example

count(
if(((rangemax (Fecha_Replan,Fecha_Replan2,Fecha_Replan3,Fecha_Replan4)-Fecha_Reco)/30.5)>18,
Id_Reco))

I think that answers your question.

Regards,

Eliran.

[JuanMu]

Hi Eliran,
Like all good solutions, easy and simple 🙂
Many thanks,
Juan Muñoz.