topic Re: How to use demonstrate functionality of input box for a bar chart? in QlikView

How to use demonstrate functionality of input box for a bar chart?

jim_chan — Thu, 07 Apr 2016 03:45:49 GMT

Hi guys,

i wanted to demonstrate a simple functionality of input box to a bar chart, that make sense. Do you guys have any samples?

I am thinking of using bar chart, maybe add in expression like sum sales and sum quantity. The input box , i will use as quantity percentage.

Scenario, if i add in 20% increase in the input box, then the bar chart should show the bar chart changes after there's 20% increase on quantity.

How to do that guys?

Rgds,

Jim

Re: How to use demonstrate functionality of input box for a bar chart?

settu_periasamy — Thu, 07 Apr 2016 04:34:49 GMT

May be try like this..

Create a variable (vIncr), and use it in your expression

=sum(value)+(sum(value)*$(vIncr))

In the InputBox, enter the value like 0.1 -> 10% 1-> 100%

Sample attached

Re: How to use demonstrate functionality of input box for a bar chart?

HirisH_V7 — Thu, 07 Apr 2016 04:44:29 GMT

Hi,

May be like this,

INPUTFIELD InputVar;
INPUTFIELD Call;

LOAD Location, 
     Value,
     0 as InputVar,
     1 as Call
FROM
[Data]
(html, codepage is 1252, embedded labels, table is @1);

At Front End:

By entering or changing the values , in the input box will make a change in Bar chart.

Hope this helps for your requirement,

PFA,

Hirish

Re: How to use demonstrate functionality of input box for a bar chart?

saniyask — Thu, 07 Apr 2016 04:47:48 GMT

Hi,

You can create a chart of your choice with dimension and expression as per your requirements. Create a Variable for eg:- VIncrease, now use this variable in dimension limits of chart property.. Create a Input Box in your GUI and use the same variable there so now as and wen there will be changes made to ur input box, the chart will change accordingly..

Hope this will help..

Saniya..

Re: How to use demonstrate functionality of input box for a bar chart?

Thu, 07 Apr 2016 06:08:22 GMT

See the attached document.

https://community.qlik.com/docs/DOC-3554