Straight table sort (Sorting condition is different)

[PrashantRupani]

Hi,

I have a straight table in Qlik Sense. I have a column which picks the dimension based on pick match function. Then the next column is a Sales measure

When the dimension is Calendar Week , then sort the table descending by most recent week. 

Calendar Week     Sales

2/28/2021               500

2/21/2021               200

2/14/2021               300

2/7/2021                 400

When the dimension is Region , sort the table descending by Sales. 

Region                   Sales

USA                       500

Canada                300

UK                          200

How do I achieve this?

[Or · Accepted solution]

Since you can't dynamically change the sort order field list as far as I know, you'd have to try and use something like sort by expression, with the expression being:

If(myPickValue='Week',Week,Aggr(Sum(Sales),Region))

Not sure if this will work, but something in that direction should be the approach, I think.

[PrashantRupani]

Thanks. 

Something along this line as you mentioned worked for me. 

Thanks again.