topic Re: Creating a sort order in QlikView

Creating a sort order

Anonymous — Wed, 27 Apr 2016 23:12:04 GMT

I have a dimension in the table with the following calculated expression, I am getting the values from 2 different columns., how do I specify the sort order for the values ?

I want sort order to be as below :

'Uptime',

'Escapes / Mo'

P0 and P1 in Production'

'FCI Top 50'

=if(match(Category,'Escapes / Mo','P0 and P1 in Production'),Category,
if(match([User Friendly Metric Name],'Uptime','FCI Top 50'),[User Friendly Metric Name]))

Thanks!

Re: Creating a sort order

swuehl — Wed, 27 Apr 2016 23:26:49 GMT

Maybe try a sort by expression with expression

=Match( if(match(Category,'Escapes / Mo','P0 and P1 in Production'),Category,
if(match([User Friendly Metric Name],'Uptime','FCI Top 50'),[User Friendly Metric Name])),

'Uptime',

'Escapes / Mo',

P0 and P1 in Production',

'FCI Top 50'

)

Re: Creating a sort order

Anonymous — Wed, 27 Apr 2016 23:35:56 GMT

Thank you .. how do I avoid sort by state .. I mean I don't want the selected value to be top of the table .. I don't see that option to disable ..

Re: Creating a sort order

sunny_talwar — Thu, 28 Apr 2016 00:10:06 GMT

I this pivot table we are talking about?

Re: Creating a sort order

sasikanth — Thu, 28 Apr 2016 04:57:10 GMT

try some thing like

wildmatch( only{1} if(match(Category,'Escapes / Mo','P0 and P1 in Production'),Category,
if(match([User Friendly Metric Name],'Uptime','FCI Top 50'),[User Friendly Metric Name])),

'Uptime',

'Escapes / Mo',

P0 and P1 in Production',

'FCI Top 50'

)

if the scroll bar is enabled in any object say List box then by default qlikview moves the selection to top.

Re: Creating a sort order

sujeetsingh — Thu, 28 Apr 2016 05:27:32 GMT

Why not to define a sort order in backend and just calling it in your sort expression at UI.

Re: Creating a sort order

jonathandienst — Thu, 28 Apr 2016 05:41:56 GMT

If the list is static, then you can do a dummy load in the script to set the sort order:

Dummy:

LOAD * Inline

[

Re: Creating a sort order

Anonymous — Thu, 28 Apr 2016 05:50:14 GMT

in sort tab have the to sort the according to the asc or desc