Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

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

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

4 Replies
settu_periasamy
Master III
Master III

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

HirisH_V7
Master
Master

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:

Input Box into variable Chart-212417.PNG

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

HirisH
“Aspire to Inspire before we Expire!”
saniyask
Creator
Creator

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..

Untitled.png

Hope this will help..

Saniya..

Not applicable

See the attached document.

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