topic Re: value expression in listbox disappears when selection is made in QlikView

value expression in listbox disappears when selection is made

curiousfellow — Wed, 25 Sep 2019 12:47:18 GMT

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 ?

Re: value expression in listbox disappears when selection is made

jaibau1993 — Wed, 25 Sep 2019 13:13:18 GMT

Hi!

I think that you shoud create the appropiate dimension in the script, something looking like "1 - Sep", "2 - Oct", etc.

Regards,

Jaime.

Re: value expression in listbox disappears when selection is made

jaibau1993 — Wed, 25 Sep 2019 13:30:49 GMT

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.

Re: value expression in listbox disappears when selection is made

curiousfellow — Wed, 25 Sep 2019 13:36:05 GMT

That works indeed, i will try to understand this expression. Thanks

😀

Re: value expression in listbox disappears when selection is made

jaibau1993 — Wed, 25 Sep 2019 13:38:14 GMT

Let me know if you do not understand how it works! 😊