How to keep the sorted by special column?

alex_stone — Thu, 22 Jun 2017 15:42:11 GMT

Currently, I have one straight table like below:

Asset Class	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	YTD Revenue
aa
bb
cc
dd

The column from Jan ~ Dec will be shown when it reach the corresponding month. e.g. Currently month is June, it will show as below.

Asset Class	Jan	Feb	Mar	Apr	May	YTD Revenue
aa
bb
cc
dd

And I want to sorted by YTD Revenue always. The sort priority will change automatically when have more month to shown on left of YTD Revenue. How to keep highest priority for YTD Revenue no matter we have how many monthes to show?

Re: How to keep the sorted by special column?

Anil_Babu_Samineni — Thu, 22 Jun 2017 15:44:52 GMT

Hello Alex, Please add this in your YTD?

Month = {'$('<=' & <=Max(Month))'}

topic Re: How to keep the sorted by special column? in QlikView

How to keep the sorted by special column?

Re: How to keep the sorted by special column?