topic How Do I Setup and Use an Input Box?? in QlikView

How Do I Setup and Use an Input Box??

Tue, 29 Nov 2011 02:52:22 GMT

I'm totally confused over this -

I have a pivot table which displays data for a series of hotels. What I want to do is return only specific hotels. Seems to me that the best way to do this would be through an Input Box. Problem is, I can't seem to figure out how to use the sucker, it's just not intuitive to set up at all. It should be easy, I don't understand why it has to be so difficult in Qlikview.

I have setup my input box in the sheet. I have a variable which I created called vHotelName. When I enter the hotel name in the box and then also choose a date from the calendar object what I get is all hotels for the entire date range. This is not what I want, I want the specific hotel which I entered in the input box.

What gives? I've tried researching this online but all explanations for creating and setting up the input box totally suck.

Who can help me?

How Do I Setup and Use an Input Box??

christophebrault — Tue, 29 Nov 2011 08:20:24 GMT

Hi,

Input box set a variable with the value you enter, but you know that. But i don't understand why you want to select a hotel with this variable. In your data, you should avec a field with the name of each hotel no ?

Why don't you just make a selection with listbox or search object ?

Usually, variable and input box are useful to give value to a variable and make operations, apply colors...

If your still want to use this method, you can use set analysis like this :

expression of your table : SUM({$<Hotel={$(=vHotelName)}>} Sales) Where Hotel is your fieldname.

How Do I Setup and Use an Input Box??

Anonymous — Thu, 01 Dec 2011 19:08:06 GMT

As Christopher pointed out, if we understood your issue properly, the best thing to do is to create a List Box; under the "General" tab name it as you see fit and into the "Field" box select the column that contains the Hotel's names.

Search should be either <use default> or Yes... and that's it.

In the List box you should now be able to either click on a Hotel name or search for one, and see your Pivot Table showing the info you want.