Discussion board where members can get started with Qlik Sense.
Can you please hlep me with the below issue i am facing in qlik sense.
My Week format is WW-MMM ex, 01-Jan
it is used in pivot table columns, while sorting the columns it is not sorting based on weekmonth combination instead there are options to sort alphabetically or number.
Need to write expression for sorting , can any one please help me with this.
Go to Solution.
This should work as a sort expression:
WildMatch(FieldName, '*Jan', '*Feb', '*Mar', '*Apr', '*May', '*Jun', '*Jul', '*Aug', '*Sep', '*Oct', '*Nov', '*Dec')
Thanks for your reply.
But this is not the case, no need to derive week from date.
This experession is sorting by months but not weeks in the same month.
Can you please suggest how weeks also can be sorted.
My issue is resolved as i have used both sorted by expression and sorted by alphabetic.
Thank you all for your valuable responses.