expression issue...

[#1]

hi all

can we calculate any expression on the bases of the value in text box or any any other object.....

like as we do in VB

If textbox.text = 'abc' ...........

how we can do the same in QV.?

[nstefaniuk]

You can do the same in Qlikview

Assuming that text is the variable of a Input Box

sum( if('$(text)' = 'abc', value1, value2))

or

if('$(text)' = 'abc', sum(value1), sum(value2))

it's not the best way to do that but it works. If you can give more clarifications on you need, we could advise the best method.

[#3]

Thnks nstefaniuk,

actualy i want to sho the chart on the basis of value input by user..........

say if user inpute item name = 'Water' then chart show the result for water only....

[CELAMBARASAN · Accepted solution]

Hi

     You can do this by using set analysis.

      Sum({<fieldName={'$(variable)'}>} fieldname)

Hope this your need

Celambarasan