topic Re: Re: about variable. in QlikView

about variable.

Mon, 26 Jan 2026 18:19:17 GMT

now I have tables.

among that, one is composed product, price.

(calculated values)

A 100 ?

B 200 ?

C 300 ?

so i wanna receive a variable(vSer) on Input box.

(maybe vSer will be 1~10 number.)

After received value, go to calculation.

ex.vSer is "4".

100*v.Ser=400

using three charts(

1. product, price

2. input box(variable)

3. result (product name, 400)

I need three variables(for A, B and C)

and hope to calculate separate values.

now Im using this in result (one expression of listbox)

if(vSer1 > 0, vSer1*price), price)

if(vSer2 > 0, vSer2*price), price)

....I know thats innocence.

Final Result I want

(variable input box) (result box)

A 4 A 400

B 2 B 400

C 9 C 2700

* I hope checking many products at same time.

thankyou

Re: about variable.

Mon, 18 Nov 2013 10:32:44 GMT

Might be something like attached.

Hope it helps!

Re: about variable.

Mon, 18 Nov 2013 10:37:08 GMT

thank you, Shyamal Pandit.

but, I want to write values each other differently

like above

ex)

A 4

B 2

C 7

in three variable block of one input box.

thank you

Re: Re: about variable.

Mon, 18 Nov 2013 10:47:42 GMT

ok, PFA.

I have achieved it using if, I think better can be done using set analysis, but I am not very sure about that.

Re: about variable.

Mon, 18 Nov 2013 11:26:48 GMT

thank you!!!!!!!

I solved it FINALLY!!

now I can solve left 20 products..

thank you again!!