Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Thanks.
Something along this line as you mentioned worked for me.
Thanks again.