topic Re: Sort not being maintained in QlikView

Sort not being maintained

JustinDallas — Thu, 07 Jan 2016 14:40:37 GMT

Hello Everyone,

I have a chart in my dashboard that I sort by an aggregate calculated value. Everyday I come in, this chart is "un-sorted" and my priority order is changed. Has anyone else suffered from this phenomenon? My Qlikview version is 11.20.12664.0 I'm at a loss of what to do.

Re: Sort not being maintained

settu_periasamy — Thu, 07 Jan 2016 14:46:18 GMT

Did you try to Uncheck the interactive chart option?

Same issue discussed here...

chart sort order changes by itself after reload

Re: Sort not being maintained

MK_QSL — Thu, 07 Jan 2016 14:49:52 GMT

Provide sample application.. Without that it's difficult to guess and work.

Re: Sort not being maintained

nagarjuna_kotha — Thu, 07 Jan 2016 15:41:44 GMT

Hi ,

Can share screenshot of you chart and on what basis you want to sort means Dim wise or expression wise?

-Nagarjuna

Re: Sort not being maintained

JustinDallas — Thu, 07 Jan 2016 15:47:17 GMT

Unfortunately, I'm not sure I can share the chart. However, I can say that the sorting should occur on an expression and not a dim.

Re: Sort not being maintained

nagarjuna_kotha — Thu, 07 Jan 2016 15:53:06 GMT

Tell me one thing,

Dim Name and on which expression you want to sort?

-Nagarjun

Re: Sort not being maintained

nagarjuna_kotha — Thu, 07 Jan 2016 15:57:09 GMT

Otherwise ,If you cannot share , try to create sample data and share, that is related to your issue.

If you want get solution in less time , Create sample data and share it.

-Nagarjun

Re: Sort not being maintained

nagarjuna_kotha — Thu, 07 Jan 2016 16:08:05 GMT

might be due to some reason,

1.if you are using Caluculated dim sometimes its not work. Try to create in backend itself

2.i pointed in your screen promote your expression to top and select only one sort type for that expression also deselect all sort types for all .

-Nagarjun

Re: Sort not being maintained

sorrakis01 — Thu, 07 Jan 2016 16:13:49 GMT

Hi,

Can you make a proof? Use the same expresion in sort by expresion.

Regards