Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
patriciousa
Creator II
Creator II

Chart - X axis order static when using afilter

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.

1 Solution

Accepted Solutions
sunny_talwar

Change your sort expression to this:

Only({1} ExistingFieldNameHere)

View solution in original post

8 Replies
sunny_talwar

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

patriciousa
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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

Change your sort expression to this:

Only({1} ExistingFieldNameHere)

patriciousa
Creator II
Creator II
Author

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

Thank you again (Twice in a day already)

Best regards!