topic Re: Create a sort order based on a Field in QlikView

Create a sort order based on a Field

HirisH_V7 — Sat, 16 Nov 2024 21:45:30 GMT

Below are two fields :

S.No	Other no
1	1
1	1
1	1
1	2
1	2
1	2
1	3
1	3
1	3
1	4
2	1
2	1
2	1
2	2
2	2
2	2
2	3
2	3
2	3
2	4

Want to achieve like this, in script itself.

S.No	Other no
1	1
1	2
1	3
1	4
1	1
1	2
1	3
1	1
1	2
1	3
2	1
2	2
2	3
2	4
2	1
2	2
2	3
2	1
2	2
2	3

Dear Qlik 'rs Please help with this.

Re: Create a sort order based on a Field

Gysbert_Wassenaar — Fri, 07 Dec 2018 11:44:53 GMT

Like this:

LOAD
    [S.No],
    Autonumber(RecNo(),[S.No]) as [Other no]
FROM
    ....

Re: Create a sort order based on a Field

HirisH_V7 — Fri, 07 Dec 2018 12:20:09 GMT

Hi Gysbert,

Code provided, gave me below result:

S.No	Other no
1	1
1	2
1	3
1	4
1	5
1	6
1	7
1	8
1	9
1	10
2	1
2	2
2	3
2	4
2	5
2	6
2	7
2	8
2	9
2	10

But I need it like this, As my post, From above data provided.

S.No ,Other no
1 ,1
1, 2
1 ,3
1 ,4
1, 1
1 ,2
1 ,3
1 ,1
1 ,2
1, 3
2 ,1
2, 2
2 ,3
2,4
2 ,1
2 ,2
2 ,3
2 ,1
2 ,2
2 ,3

Thanks,

Hirish

Re: Create a sort order based on a Field

Gysbert_Wassenaar — Fri, 07 Dec 2018 13:17:49 GMT

Ah, my mistake. Try this:

LOAD
    [S.No],
    Autonumber(RecNo(),[S.No] & '|' & [Other no]) as [Other no]
FROM
    ....

Re: Create a sort order based on a Field

HirisH_V7 — Sat, 08 Dec 2018 06:17:59 GMT

Hi My main objective is not to have a same Name in sequence when i select any S.no as below, all should be shuffled but not in sequence. pl help me with this.

PFA QVW for Reference and do the needful.

Many Thanks,

Hirish V