Solved: Please help regarding below example.. - Qlik Community

nikhilgarg · ‎2014-09-26

Hey,

Let say i have an input box and i entered a year. According to that year i want the sum of salary.

How can i achieve this ??

How to put input box where user can input value and how to get sum of salary according to inputed value ??

Can anyone help??

Thanks

khalander · ‎2014-09-26

Hi,

Create one empty variable like below screenshot

Then create new Input box and add that empty variable like below.

Then add expression as Sum({<Year={$(vInputYear)} >} Value) like below image.

After that enter year in input box it will effect in chart also because we have given that variable in that chart also.

Regards,

khalander

View solution in original post

Anonymous · ‎2014-09-26

you Need to define a variable "vInputYear"

and in your table, Chart you have to use set analysis

sum({<MyYear={'$(=vInputYear)'}>}Dact)

nikhilgarg · ‎2014-09-26

Hey,

Thanks i got your point but can you tell me how to create an input box with label say(Input year) and then how to map this value with variable created say "vInputYear" ??

Thanks

senpradip007 · ‎2014-09-26

PFA. Hope it will help you.

nikhilgarg · ‎2014-09-26

HEy,

I am using trial version of qlikview so cannnot open your document . So can you kindly tell me here how to acheive what i want ...

Thanks

flipside · ‎2014-09-26

An alternative way you could consider is loading your year values as a separate field in an island table, e.g...

Data:

Load * inline [
Year, Val
1990, 23
1990, 24
1991, 2
1992, 32
1992, -3
1992, 0.5
];

YearSelects:
Load distinct Year as sYear resident Data;

Then you can have a listbox or multibox for users to select the year (remembering to set the One Selected Value setting) and display the sum of Val (in my example) by using ...

=sum({<Year={'$(#=sYear)'}>} Val)

This saves on having a variable and the user can only select valid values.

flipside

Anonymous · ‎2014-09-26

i attach you a test qvw

senpradip007 · ‎2014-09-26

In the input box property go to General tab ----> Select variable named vInputYear ----> same is showing in the Label ----> edit vInputYear as Input Year.

svsudhakar · ‎2014-09-26

Hi nikil,

create one new Sheet Object "Input Box" and -->Clik New Variable and named it as "vInputYear" -->

Click ok and write the sum({<MyYear={'$(=vInputYear)'}>}Dact)

nikhilgarg · ‎2014-09-26

HEy,

I am using trial version of qlikview so cannnot open your attached file . So can you kindly tell me here how to acheive what i want ...

Thanks