topic Re: Chart - X axis order static when using afilter in App Development

Chart - X axis order static when using afilter

patriciousa — Wed, 23 Mar 2016 14:55:33 GMT

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.

Re: Chart - X axis order static when using afilter

sunny_talwar — Wed, 23 Mar 2016 15:01:49 GMT

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

Re: Chart - X axis order static when using afilter

patriciousa — Wed, 23 Mar 2016 15:04:29 GMT

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

sunny_talwar — Wed, 23 Mar 2016 15:06:50 GMT

1) What is your current expression?

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

Re: Chart - X axis order static when using afilter

patriciousa — Wed, 23 Mar 2016 15:12:53 GMT

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

sunny_talwar — Wed, 23 Mar 2016 15:15:19 GMT

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

Re: Chart - X axis order static when using afilter

patriciousa — Wed, 23 Mar 2016 15:15:39 GMT

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

Re: Chart - X axis order static when using afilter

sunny_talwar — Wed, 23 Mar 2016 15:17:30 GMT

Change your sort expression to this:

Only({1} ExistingFieldNameHere)

Re: Chart - X axis order static when using afilter

patriciousa — Wed, 23 Mar 2016 15:21:27 GMT

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

Thank you again (Twice in a day already)

Best regards!