Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to get Month_Year Sorting order in Qlikview multibox Expression.
Suppose Fileld Name like Month_Name:
Month_Name
Apr_2018
Jun_2018
Nov_2017
Feb_2018
Sep_2017
May_2018
Dec_2018
Mar_2018
Jan_2018
Oct_2017.
I need to show Drop down list like this in multi box:
Month_Name
Jun_2018
May_2018
Apr_2018
Mar_2018
Feb__2018
Jan_2018
Dec_2017
Nov_2017
Oct_2017
Sep_2017.
Thanks
Hi Rakesh,
Thanks. Will try
try loading your Month_Name field as proper Date (Dual value containing numerical part):
hope this helps
regards
Marco