How to sort my Table in sequencs ?

[paulyeo11]

Hi All

My Table 2 dimension is period by month , now i not sort in sequences.

Table 1 and Table 3 is list box , it work fine.

Can some one advise me.

Paul Yeo

[paulyeo11]

my QVW

[Anil_Babu_Samineni · Accepted solution]

May be this as expression?

Aggr(SUM(C_ONHAND_AMT), (Duration1, (NUMERIC, ASCENDING)))

OR, You can try in script level using Dual() like Nested IF Statements

[paulyeo11]

Hi Anil

Thank you for your sharing.

I try to put the expression at Table 2 dimension  :-

Aggr(SUM(C_ONHAND_AMT), (Duration1, (NUMERIC, ASCENDING)))

it does not display any thing , where i go wrong ?

Paul Yeo

[Anil_Babu_Samineni]

This should be an Expression

And, Note - It will work when you have more thatn QV12 versions only. Are you using same?

[uacg0009]

Hi,

If your values in Duration1 are all fixed, how about create a table for sorted in script, then use it to sorted your table?

Sorry I have a question, I found that in your example, when I select in list box,the color is not the default green. Could you please tell me how to change that?

Thanks.

Aiolos

[paulyeo11]

Hi Aiolos

Pls go to list box , right click proprity , then go to Tab = Caption , then click on Active caption and change the back ground color.

Paul Yeo

[paulyeo11]

Hi Anil

I have tested your expression , it work fine on Qlik Sense. since you are so good , i like to ask you how to make the Row 1 >60 Mth move to below , display at row "58-60 Mth" .

Below is the sequences generate by QS , which is not correct :-

Duration1	Aggr(SUM(C_ONHAND_AMT), (Duration1, (NUMERIC, ASCENDING)))
>60 Mth	7,936.15
1-3 Mth	640,854.17
4-6 Mth	135,897.58
7-9 Mth	71,247.18
10-12 Mth	116,366.76
13-15 Mth	34,175.59
16-18 Mth	44,734.08
19-21 Mth	19,946.77
22-24 Mth	14,189.18
25-27 Mth	11,370.80
28-30 Mth	28,694.83
31-33 Mth	23,748.01
34-36 Mth	15,806.44
37-39 Mth	14,801.39
40-42 Mth	17,634.22
43-45 Mth	12,573.30
46-48 Mth	8,546.26
49-51 Mth	9,854.55
52-54 Mth	5,042.12
55-57 Mth	11,798.88
58-60 Mth	5,002.79
Fast Moving	215,512.14

[Anil_Babu_Samineni]

First of all, You mark yourself only not the correct one.

And, To solve that you must need Dual() function to each ..

[uacg0009]

Hi Yeo,

Thanks to reply, well, actually I know that the active caption color, maybe I didn't clarify what I want to ask.

I didn't mean the caption of list box, I see that when I select the value of the list box, the color is not default green.

I just want to know how to make that?

Thanks.

Aiolos