Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to import a sales funnel with lots of projects that have end dates in the DD/MM/YYYY format.
I have already added another column of dates using the =text(date,"MMM-YY").
However I cannot get Qlik to either:
I don't know if the problem is solved in:
Any help would be appreciated.
Your sorting seems to be based on the expression desc instead of sort by MonthYear dimension
hi,
i am not using any expressions. How do I get the sorting to be based on the month year dimension?
regards
oliver
To sort the dates in Sep, Oct, Nov Dec...
you need to do it in Sorting for the chart, properties.
Sort by expression.
Maybe use below expression and change Yourexpression with your actual expression.
aggr(YourExpressionHere), MonthYear)
Either use Ascending or Descending upon your requirement.
If the you found the result, please close this by marking it Correct Answer.
Thanks.
Hi,
I have just solved it with your help!
Thank you very much!
Hi
How do I mark it has correct answer?
Check on the left bottom of the post and click 'Correct Answer'
Thanks.