Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be use set analysis to stop the particular field from filtering out: {<FieldName=>}
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.
1) What is your current expression?
2) Which field/fields are you trying to avoid selection on?
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.
The order of chart changes? Have you used a sorting expression?
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
Change your sort expression to this:
Only({1} ExistingFieldNameHere)
Sunny, I'm serious, you are my savior.
Thank you again (Twice in a day already)
Best regards!