If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
When the dimension is Region , sort the table descending by Sales.
How do I achieve this?
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:
Not sure if this will work, but something in that direction should be the approach, I think.
View solution in original post
Something along this line as you mentioned worked for me.