Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

how can I fill a variable with a query for an input box

I hope somebody can help me.

I have an input box and I want fill it with a names from a query, I use an variable called cliente and I want a list dropdown.

is this posible?

best regards

1 Solution

Accepted Solutions
Not applicable

Re: how can I fill a variable with a query for an input box

Do u want something like this..

Plz see attached application.

Check the Constraints Tab of listbox if ur requirement fulfills.

6 Replies
eliran_s
Contributor II

how can I fill a variable with a query for an input box

Hi,

You can't populate an input box with drop down list.

If the list of clients is at hand, create a field containing it and assign the field to a multi box object.

If it's not answering your question, please clarify what are the needs from this variable.

Eliran.

Not applicable

Re: how can I fill a variable with a query for an input box

Do u want something like this..

Plz see attached application.

Check the Constraints Tab of listbox if ur requirement fulfills.

Not applicable

Re: how can I fill a variable with a query for an input box

take an input box add a variable and where ever you want to querry it, just call the variable..

check out the sample attached

Not applicable

Re: how can I fill a variable with a query for an input box

sorry pls refer to this attachment and drop down you get it from constraint tab

qlikviewajeet
New Contributor III

how can I fill a variable with a query for an input box

Right click on sheet
go to new sheet object
select input box chart
make a title any like top n customer
add a variable (click on new variable)
give name as N
go to constraint
check Enable edit Expression
Value - give any 10 / 20 etc
Value list - predefined values in drop drown - predefined values will get enabled -
select range - you can select list values to make exact range-
make a chart - select dimension as customer- expression sum(sales) - go to presentation -
select max number(1-100)- put name in expression as your variable (N)
by this when ever u will make query, this variable will response. like u slect top variable 6
top 6 customer's records are fetched from this query

Not applicable

how can I fill a variable with a query for an input box

Thanks a lot Erika, you really help me so much.
best regards.