topic Re: Input Box in QlikView

Input Box

Mon, 01 Sep 2014 08:16:51 GMT

Hi,

Can you please explain me about input box and its use.

Somewhere i have seen a graph with one bar forcasting the future years sales or something. I guess its related to input box.

Thanks in advance.

Re: Input Box

MK_QSL — Mon, 01 Sep 2014 08:19:38 GMT

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/01/loading-data-into-input-boxes

Loading Data into Input Boxes

http://www.qlikcommunity.com/thread/57172

Re: Input Box

ashfaq_haseeb — Mon, 01 Sep 2014 08:19:52 GMT

Hi,

You can use I/P box to modify your variables.

have a look at below post

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/01/loading-data-into-input-boxes

And sample example attached

Regards

ASHFAQ

Re: Input Box

Mon, 01 Sep 2014 08:53:28 GMT

how do i associate a variable with a bar chart.

as mentioned above, i want to show the forecast

Re: Input Box

israrkhan — Mon, 01 Sep 2014 09:11:36 GMT

create a variable AND create an input box.

than in the chart expression, use the variable instead of field name..

like if you have expression, sum(unitprice) - sum(Discount)

you can use variable as replacement of discount, you can take Discount from user in input box..

and change expression like, sum(unitprice) - sum($(variable))

what ever value you will enter in the input box, will come into this variable..

Re: Input Box

Mon, 01 Sep 2014 09:55:29 GMT

could you plz break it down further .

i have months in dimension axia and sales in expression axis.

I have created a variable and input box

i cant figure out what is going wrong

Re: Input Box

israrkhan — Mon, 01 Sep 2014 10:19:55 GMT

you have month in dimension, and what is expression,?

and what you wana do, let me know?

if possible, share the documets

Re: Input Box

Mon, 01 Sep 2014 10:34:41 GMT

its a bar graph with months in x axia and sales in y axis.

i want to predict the next months sales.(through input box and variable)

thats it

Re: Input Box

israrkhan — Mon, 01 Sep 2014 10:39:56 GMT

what expression , you will use to calculate next month sale...?

Re: Input Box

Mon, 01 Sep 2014 10:41:10 GMT

thats wat i need

Re: Input Box

engishfaque — Mon, 01 Sep 2014 10:44:50 GMT

Dear Deepak,

An input box consists of three columns in a multi box like layout. The first column shows a list of variables. The second column equal signs '=' and the third column the values of the variables. It can contain one or many variables, each one on a separate row.

In an input box the current value of the variable is shown. By clicking on a value in the input box, the cell will turn into edit mode, so that a new value can be entered or the old one modified. If the variable contains a formula, that will now be shown rather than its result. The cell in edit mode will normally contain a ... button which opens up a full editor window to facilitate creation of advanced formulas. The function of a variable value cell in an input box could very well be compared to that of a cell in a spreadsheet.

Reference: QlikView Reference Manul

Kind regards,

Ishfaque Ahmed

Re: Input Box

israrkhan — Mon, 01 Sep 2014 11:12:21 GMT

ahhhh, you need predictive analysis..

in qlikview you can do the same with "What if Analysis"

for this you need to read little bit, and see the thread below..

and search for "what if analysis" in community

Develop a what-if analysis with QlikView

QlikView What If Analysis with Sliders - YouTube

hope it helps...