topic Re: Multibox Display in QlikView

Multibox Display

Anonymous — Tue, 09 Apr 2013 13:01:48 GMT

Hi All,

I have listbox which has a list of values.

When I make selection in the application the multibox has only one possible values and others are excluded values.

But my multibox is not showing the one possible value but If I click the drop down I could see the values.

This worked when I tried with a sample one but not in my application.

=> in normal it didnt show any value

=>but it has only one possible value, still not showing

Can anyone help me in this??

Thanks in advance.

~Leni

Re: Multibox Display

Wed, 05 Mar 2014 13:11:01 GMT

Quite a long time query.

I had one similar requirement in my app, I had a work around by using an expression and a variable.

Create a Variable vPeriod and set its value to Acc.Period in the Document Properties->Variables Tab.

In the Multibox use the expression as ;

=if(Acc.Period='$(vPeriod)',Acc.Date)

This may be a solution to your problem too ... Try and let me know if it is resolved.

Re: Multibox Display

sudeepkm — Wed, 05 Mar 2014 13:29:26 GMT

I think when you add expressions to a Multi box and you make single value selection it does not show that single value in it but it works for fields mentioned in the Script. May be if possible create a calculated field in your load script and display it in the multi box.

Re: Multibox Display

jonathandienst — Wed, 05 Mar 2014 13:39:18 GMT

Leni

Perhaps there are some nulls in that field. They will not show in the multibox, but they will prevent the date showing as there are two states - the single value or a null. When you make a selection of the one possible date, you will exclude the nulls.

HTH

Jonathan