Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
HirisH_V7
Honored Contributor

Create a sort order based on a Field

Below are two fields :

S.NoOther no
11
11
11
12
12
12
13
13
13
14
21
21
21
22
22
22
23
23
23
24

 

Want to achieve like this, in script itself.

S.NoOther no
11
12
13
14
11
12
13
11
12
13
21
22
23
24
21
22
23
21
22
23

 

Dear Qlik 'rs Please help with this.

 

HirisH
“Aspire to Inspire before we Expire!”
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Create a sort order based on a Field

Ah, my mistake. Try this:

 

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

talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: Create a sort order based on a Field

Like this:

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

 

 


talk is cheap, supply exceeds demand
HirisH_V7
Honored Contributor

Re: Create a sort order based on a Field

Hi Gysbert,

Code provided, gave me below result:

S.NoOther no
11
12
13
14
15
16
17
18
19
110
21
22
23
24
25
26
27
28
29
210



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

HirisH
“Aspire to Inspire before we Expire!”
MVP & Luminary
MVP & Luminary

Re: Create a sort order based on a Field

Ah, my mistake. Try this:

 

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

talk is cheap, supply exceeds demand
HirisH_V7
Honored Contributor

Re: Create a sort order based on a Field

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.

Capture.PNG

PFA QVW for Reference and do the needful.

 

Many Thanks,

Hirish V

HirisH
“Aspire to Inspire before we Expire!”