Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Our financial year starts in september. So september is month 1, october = month 2 etc,etc
Now I want users to select monthnumber in a listbox, but I want to display the name of the month too.
so I made an expression like this :
=left(
if( Monthnumber < 5,
aggr(Only({1}monthname('1-'&(Monthnumber+8)&'-2019' )),Monthnumber) ,aggr(Only({1}monthname('1-'&(Monthnumber-4) &'-2019')),Monthnumber)
)
,3)
When no selection is made all monthnames are displayed but when a month is selected only that monthname is displayed and others are not.
Please see attached qvw
How to achieve that monthnames are allways displayed in my listbox ?
But, if you still want to do it in the front-side, try something like
Month(Date#(if(Only({1}Monthnumber) = 4, 12, Mod(Only({1}Monthnumber)+8, 12)), 'M'))
Regards,
Jaime.
Hi!
I think that you shoud create the appropiate dimension in the script, something looking like "1 - Sep", "2 - Oct", etc.
Regards,
Jaime.
But, if you still want to do it in the front-side, try something like
Month(Date#(if(Only({1}Monthnumber) = 4, 12, Mod(Only({1}Monthnumber)+8, 12)), 'M'))
Regards,
Jaime.
That works indeed, i will try to understand this expression. Thanks
😀
Let me know if you do not understand how it works! 😊