Custom Sorting:Always show most recent weeks on the top in barchart

[grajmca_sgp123]

Hi All,

I have a bar chart with dimension as Weeks and two expressions sum(qty) and sum(sales).

I would like it to sort in order like always most recent weeks(FW 31,FW 30,FW 29......) on top in barchart .

I want to sort the dimensions in the following order:

FW31---always current week on top.

FW30

FW29

is there any way I can do this custom sorting.

Thanks

[preminqlik · Accepted solution]

go to sort tab of the chart properties and select dimension and sort by the following expression , Descending order

=only({1}keepchar(Weeks,'0123456789'))

or

=only({1}Purgechar(Weeks,'FW'))

[antoniotiman]

Try in Sort Tab, set Text Z-> A

[settu_periasamy]

Hi,

Try this,

In the Sort tab,

Uncheck the state, and Text as Z-> A

[grajmca_sgp123]

Thanks your reply ,your solutions works if we want to sort the weeks ascending and descending order.

But I am looking for current weeks on top like below order.

Sort this from most current FW to oldest.

Most recernt FW to oldest FW...

Example:

FW31

FW30

is there any way I can do this custom sorting.

Thanks

[grajmca_sgp123]

is there any way how we can achieve this custom sorting.

Sort this from most current FW to oldest.

Most recernt FW to oldest FW...

Example:

FW31

FW30

[settu_periasamy]

Hi Rajesh,

Can you post the sample qvw?

[preminqlik]

i guess whatever i suggested for most current weeks only,

can you post the sample ?

[grajmca_sgp123]

thank u your solution is works fine.. I missed some thing earlier.