Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, New to Qlik Sense and I have created a multi select button for months, but I want the months to display as the month name but keep the correct month order, ie Jan to Dec. Can anyone help please? Thanks
@ZebLearney if I understood correctly
in sort use sort by number
The months are currently displayed as numbers 1-12, but I want to convert them to name Jan-Dec, but still keep the sort order correct as Jan-Dec. It is a multi select button I have created, custom object field UI with field Month. Thanks
Month(Date) and sort by number
can you share a sample data if if this is not what I understood
This is what I have
=Month(Date) worked! Thanks
the problem is solved?
Yes that part solved thankyou @Taoufiq_Zarra . I have another problem now. I want to have a default on this month selector to select current month via an Action, do you know what the expression should be on the action to do this? Basically when I open the report it should automatically default to the current month selected. Thanks