List Box sorting based on Expression

[azimabadi]

Hi everybody,

i have a list box containing the Months. I need to sort this list box so that list begins with "Jul". I did this with a sort expression :

= MOD( ( Calendar.Month + 5 ) , 12 ) + 1

Works good! But as soon as i select one or more months, i get this result :

I understand because of my selection, the "Calendar.Month" is NULL for all nonselected Months and therefor QV can not calculate the expression.

But i need the result as is shown below:

It's like the way QV shows the List Box when i select "Numeric Value" as Sort order:

that means i want to keep the order from my Expression as i select some Months.

I appreciate any idea.

Best regards - Peyman

[#2 · Accepted solution]

You have to tell QlikView that the expression should be calculated on the full model instead on only on the selection. This is done with the set analysis expression {1}. I think it should be something like:

= MOD( ( Only({1} Calendar.Month) + 5 ) , 12 ) + 1

JG

[alexandros17]

Here is an example, hope it helps

[#4]

Hi Peyman,

You can calculate the position of the month in the script.

Then in the List Box, your expression will be Sum({1} DISTINCT Calendar.MonthOrder) and then, even if you select a month, the order will be show for all months.

Hope it helps.

Best regards,

Nicolas

[#5]

Based on the alexandros17 sample, I have adapted the expressions with the MOD( ( Only({1} order) + 5 ) , 12 ) + 1 formula:

JG

[azimabadi]

Hi Nicolas,

in this case i need to change begining Month dynamicly on interface, user can select the begining month and i have to calculate some expressions based on this selected begining Month. That is why i can't calculate a new order in my script.

thank you so much

Peyman

[azimabadi]

Thx so much JG,

i'm surpreised how i forget everytime set analysis!!!

Best regards

Peyman