Chart - X axis order static when using afilter

[patriciousa]

Hi Community.

I have a bar chart and a Line chart (Screenshot) that I need the X axis to not move at all.

When I make a Selection in the table on the right, the X axis changes the order of the values. How can I keep it static?

Thank you in advance.

Regards.

[sunny_talwar]

May be use set analysis to stop the particular field from filtering out: {<FieldName=>}

[patriciousa]

Hi again Sunny. I'm still a newbie in using Qlik. I have no clue what you mean when you say set analysis. (I know 0 coding and computer stuff, that's why I make dumb questions in the forums but I manage to work it it out )

Thank you.

Kind regards.

[sunny_talwar]

1) What is your current expression?

2) Which field/fields are you trying to avoid selection on?

[patriciousa]

Chart Y axis.

((Sum({<Categoría={"Senior", "JP", "JPE"},"Tipo Hora"={"EXAMN"}>} Cantidad))/8 )+ (Sum({1} 0))

Chart X Axis

[Fecha Registro.Calendar.Month]

When I select some guys from the table in the right, the X axix changes the order of the months.

The name of the guys come with the field " Replace(Nombre, ',', ' ') "

Thank you.

Regards.

[sunny_talwar]

The order of chart changes? Have you used a sorting expression?

[patriciousa]

And I forgot, because I didn't know how to put July as first month of the year.... the X axis is being sorted by expression. which is "NumeroMes"

Numero     Mes

1                July

2               August

3               etc

[sunny_talwar · Accepted solution]

Change your sort expression to this:

Only({1} ExistingFieldNameHere)

[patriciousa]

Sunny, I'm serious, you are my savior.

Thank you again (Twice in a day already)

Best regards!