topic Re: Sorting Help???? in QlikView

Sorting Help????

amit_saini — Thu, 22 May 2014 10:10:57 GMT

Hi Folks,

I'm having Pivot table as below:

Is there any possibility of sorting order according to your choice .Please see below i want Un Bold labels to come in this order:

Thanks,

Re: Sorting Help????

lironbaram — Thu, 22 May 2014 10:18:48 GMT

if i understand the image

sum of the fields are vertical dimensions label , and some are values in a horizontal dimension

if this is the case as far as i know you can't order them as you want, those are diffrent types of columns

Re: Sorting Help????

satishkurra — Thu, 22 May 2014 10:27:29 GMT

Please find the below example.

Please follow the below order of script for CUSTOM SORT.

Temp:

LOAD * Inline [

Re: Sorting Help????

amit_saini — Thu, 22 May 2014 10:31:06 GMT

Liron,

All these labels are under one calculated Dimension named as Downtime-Cat-Desc. Instead of vertical view i made them as Horizontal view. I just want to change order of these labels , if possible in the same view as mentioned in First image.

For example after Downtime-Cat-Desc. , I want to see first Maschinenstorung instead of Anfahren\Abfahren as first view if possible , vertical view should remain the same.

Only order will change after Downtime-Cat-Desc as below :

Thanks,

Re: Sorting Help????

lironbaram — Thu, 22 May 2014 10:40:39 GMT

if this is the case then yes

you could load an inline table

somthing like :

Downtime-Cat-Desc, sortorder

fiedvalue ,1

fieldvalue,2

that holds the sort number for each value

and in the sort tab you sort by expression and in the expression you write

= sortorder

Re: Sorting Help????

mdmukramali — Thu, 22 May 2014 10:45:37 GMT

Dear,

if you want to sort by your choice then create a Inline table.

kindly find the attached document.

Thanks,

Mukram.

Re: Sorting Help????

SunilChauhan — Thu, 22 May 2014 10:51:33 GMT

use in sort expression

wildmatch(fieldname,'value1yowwant','Valu2youwant','value3youwant',........)

you can as many as ValueNyou want in above expression

and try ascending or descending as you want

hope this helps