Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

patriciousa
Contributor

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
Highlighted

Re: Chart - X axis order static when using afilter

Change your sort expression to this:

Only({1} ExistingFieldNameHere)

8 Replies

Re: Chart - X axis order static when using afilter

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

patriciousa
Contributor

Re: Chart - X axis order static when using afilter

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.

Re: Chart - X axis order static when using afilter

1) What is your current expression?

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

patriciousa
Contributor

Re: Chart - X axis order static when using afilter

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.

Re: Chart - X axis order static when using afilter

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

patriciousa
Contributor

Re: Chart - X axis order static when using afilter

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

Highlighted

Re: Chart - X axis order static when using afilter

Change your sort expression to this:

Only({1} ExistingFieldNameHere)

patriciousa
Contributor

Re: Chart - X axis order static when using afilter

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

Thank you again (Twice in a day already)

Best regards!

Community Browser