topic Re: Sorting based on two columns in qliksense straight table in App Development

Sorting based on two columns in qliksense straight table

abhijith28 — Tue, 05 Apr 2022 07:44:00 GMT

Hi,

I have a scenario where sorting in straight table should be done on two columns.

1. Name sort by alphabetical order

2. Value sort by Sort_ord within the name

Ex: Input

Expected Output

I tried sorting option 1. sort by Name alphabetical 2. sum(Sort_ord) but its not working for few names attached in the Data.xls

I have attached the sample app and sample source data. Please look into it.

Re: Sorting based on two columns in qliksense straight table

brunobertels — Tue, 05 Apr 2022 08:47:57 GMT

Is this what you need ?

if yes is the Order in sorting menu option :

Re: Sorting based on two columns in qliksense straight table

abhijith28 — Tue, 05 Apr 2022 08:52:18 GMT

HI @brunobertels

Output is correct but the Sort_ord column should not be added in the table.

Only Name & Value should be there in the table

Re: Sorting based on two columns in qliksense straight table

brunobertels — Tue, 05 Apr 2022 15:17:28 GMT

Then do it like that

replace dim value by this calculated dimension :

=dual(Value,Sort_ord)

Let column Sort_ord but add 0 in the show column if option

like that :

and as result :

Re: Sorting based on two columns in qliksense straight table

abhijith28 — Tue, 05 Apr 2022 17:27:47 GMT

@brunobertels

Great! It is working as expected.

Thanks for your time & providing the solution.

But if you select Value "A" from first cell only that particular cell value will be selected. It won't select A from all Names. How do we tackle this issue.

Re: Sorting based on two columns in qliksense straight table

abhijith28 — Wed, 06 Apr 2022 14:42:54 GMT

@MarcoWedel @Anil_Babu_Samineni @tresB

Do you have any solution to this scenario. Please suggest

Re: Sorting based on two columns in qliksense straight table

brunobertels — Thu, 07 Apr 2022 15:22:26 GMT

This seems to work for me :

Dim = Name

Dim = Value

Sort Order :

Name = Auto

Value = order by expression ascending

add this expression aggr(min(Sort_Ord),Value)

selecting first Value in Value Field ( A) seems to select all respective value corresponding to 'A' :

Re: Sorting based on two columns in qliksense straight table

abhijith28 — Thu, 07 Apr 2022 18:26:31 GMT

@brunobertels

Thanks for the response.

Tried it but if you see the third value is showing it as B instead it should show X-B