Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a question. I have load a calendar data successfully. When I want to show Month Field using list box, the first data is Dec not Jan. I have two field to be used in sort column, MonthNum (1-12) and MonthName (Jan-Dec). Anybody knows the method to sort month name correctly ?
Really appreciate your help, thanks
Hi Indra,
For this you need to uncheck the following option
Properties -> Sort -> Uncheck State option.
Regards,
Jagan.
Hi Jagan,
I have already uncheck the state option. I only check expression option and add the expression.
Still dont get the problem why. really confuse about it.
thanks
Hi Indra,
Can you attach the sample file?
Regards,
Jagan.
Hi,
Sorry Jagan, i cant attach any file.
Is there any possibilities that the problem comes from the load order and makes Dec show in the first row ?
When i'm not choose the month it shows correctly,
Jan - Dec
But when i choose one month i mixed up again.
Hi,
may be like this, in Sort - > Expression (remove all other sort selection )
=Match(MonthName,'Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov')
Hi Indra,
Can you attach the screenshot of the Sort tab?
Regards,
jagan
Use Only({1}MonthNum) in Sort tab -> Expression
Regards,
KKR
Hi Kran,
Wow, super thanks Kran. It solved my problem. But can you explain why i need to use Only{1} like that ? Still dont get the idea.
Thanks
Hi,
If you use this approach then in every Month listbox in the Dashboard you have to use this. This is not a feasible solution.
Regards,
Jagan.
Hi Jagan
Do you mean that when i select Jan in first sheet, Month in the other sheet will be Jan also ? Can you give me the sample scenario ?
thanks for your opinion