qlikview

[Anonymous]

Hi All,

This i want to acheive dynamically not in script.

Below is the scenario which i want to achieve. i have two input box in which we can set any value.

value from first input box should be multiplied with date1's percentage and value from input box 2 should be multiplied by date2's percentage.  output should be (percentage*inputbox1 value) for date1 and (percentage*inputbox2 value) for date2

date	area	percentage	output	output
1	a	0.2	Percentage * value from inputbox1	.2 * 4
1	b	0.5	Percentage * value from inputbox1	.5 * 4
1	c	0.3	Percentage * value from inputbox1	.3 * 4
2	a	0.4	Percentage * value from inputbox2	0.4 *6
2	b	0.5	Percentage * value from inputbox2	.5 * 6
2	c	0.6	Percentage * value from inputbox2	0.6* 6
	input box1(for date 1)	input box2(for date2)
	4	6

[aarkay29 · Accepted solution]

PFA