topic Need help with input variable in QlikView

Need help with input variable

Sun, 16 Dec 2012 16:11:20 GMT

S.no	Subject1	Subject2	Class
1	520	6175	A
2	315	1400	B
3	623	445	C
5	25	45	A
6	225	702	B
7	3654	1512	C
8	4005	13350	A
9	1575	3060	B

need to create input showing the % of Subject 1 value. for eg if i put 5 % in input box i shud get a chart/table showing the value of subject1 which is 5% of subject2.

Re: Need help with input variable

Sun, 16 Dec 2012 16:55:50 GMT

Hi qlikviewnext,

I would create a new field during the load instead of a variable. The new field has all values (ratios) and can be used as a filter for ex. via a listbox. See attached app for more details.

HtH

Roland

Note:

The current selection was made using "<=30%" as searchstring of the listbox.

Re: Need help with input variable

sujeetsingh — Mon, 17 Dec 2012 07:05:15 GMT

Roland,,

A nice reply... but why not to give a input box with a variable set up..

Re: Need help with input variable

Mon, 17 Dec 2012 11:20:54 GMT

Looking for input variable solution..I've 1 more field Completed%. So i wud ve 2 variables 1 for x% of subject values and other for completed %.

Re: Need help with input variable

fosuzuki — Tue, 18 Dec 2012 18:02:31 GMT

I'd use a part of Roland's solution, which is to create the ratios in the load script.

Then, in the interface, your expression could use set analysis like:

sum({<SubjectRatio={"<=0.30"}>} Value) this would calculate the "Value" for the items where SubjectRatio is less than or equal 30%.

Hope this helps

Fernando

Re: Need help with input variable

Tue, 18 Dec 2012 19:11:27 GMT

Hi Son of Sardar,

thank you for compliments.

I prefer the use of a field instead of a variable because its calculation is done during loadtime. The calc of a variable (often even if you don't need it) is done during user onlinetime. This means not much in a smaller enviroment with a few users and small data. But it may slow down applications working on poor hardware and(or) hugh amounts of data.

Second reason is that it seems to me to be more flexible, ie in listboxes and in SET Analysis (like Fernando posted)

Re: Need help with input variable

fosuzuki — Tue, 18 Dec 2012 19:47:43 GMT

I agree with you Roland. Always when possible do the calculation in the script. It will avoid degradation in performance for the end user. Especially when you are dealing with millions of rows, this can make a huge difference.