topic Re: put in an input box a value an use like list box in QlikView

put in an input box a value an use like list box

Wed, 01 Oct 2014 22:47:09 GMT

Hi dear experts,

could we put a value in a input box and present like a list of values and use like a filter?

a mean if a set a variable with a field values then use that variable like list for filter in the report.

best regards.

Re: put in an input box a value an use like list box

Anonymous — Thu, 02 Oct 2014 00:06:51 GMT

Hi Roldan

It is possible to create a drop down list in a input box but I don't know of anyway to use it as a filter . I would just create a field in the script with an inline table and use that.

Re: put in an input box a value an use like list box

Thu, 02 Oct 2014 15:06:19 GMT

Hi Bella,

thanks for answer, well the reason is because in the input box with drop down list we only select one value at time and in ohter option , it is to much problems because the report it has to many conditions.

so I made the drop down list but I dont know jet how can set the value of the field with this variable,

tried with a trigger but when I select the drop down list value it not filter the report.

any idea?

best regards.

Re: put in an input box a value an use like list box

giakoum — Thu, 02 Oct 2014 15:14:22 GMT

You can use set analysis to use the variable as a filter in your expressions :

For example :

sum({<Month=["$(Variable1)"]>} Sales)

Re: put in an input box a value an use like list box

Thu, 02 Oct 2014 15:48:48 GMT

Thanks Ioannis,

where I can configure that part?

best regards.

Re: put in an input box a value an use like list box

giakoum — Thu, 02 Oct 2014 17:10:37 GMT

not sure what you mean.

This is an expression within the chart.

And the variable I guess you know how to setup since you already have the drop down.

Please elaborate.

Re: Re: put in an input box a value an use like list box

Thu, 02 Oct 2014 17:39:30 GMT

thanks Ioannis ,

I see where

but for example in this example(attached file) it Works I mean the value apear but is not selected.

there's any way to select in the same time of the variable is seting?

regards