Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amit_saini
Honored Contributor III

Sorting Help????

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,

AS

1 Solution

Accepted Solutions
satishkurra
Valued Contributor II

Re: Sorting Help????

Hi

Please find the below example.

Hi

Please follow the below order of script for CUSTOM SORT.

Temp:

LOAD * Inline [

Category

Meat

Fish

Chicken

];

Data:

LOAD * INLINE [

Category,Sales

Fish,100

Meat,200

Chicken,450

];

DROP Table Temp;

Note:

Reload the script. Modify the properties of the Category list box and on the Sort tab,

set the Sort by option to Load Order.

6 Replies
lironbaram
Honored Contributor II

Re: Sorting Help????

hi

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

satishkurra
Valued Contributor II

Re: Sorting Help????

Hi

Please find the below example.

Hi

Please follow the below order of script for CUSTOM SORT.

Temp:

LOAD * Inline [

Category

Meat

Fish

Chicken

];

Data:

LOAD * INLINE [

Category,Sales

Fish,100

Meat,200

Chicken,450

];

DROP Table Temp;

Note:

Reload the script. Modify the properties of the Category list box and on the Sort tab,

set the Sort by option to Load Order.

amit_saini
Honored Contributor III

Re: Sorting Help????

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,

AS

lironbaram
Honored Contributor II

Re: Sorting Help????

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

mdmukramali
Valued Contributor II

Re: Sorting Help????

Dear,

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

kindly find the attached document.

Thanks,

Mukram.

chauhans85
Esteemed Contributor

Re: Sorting Help????

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

Community Browser