topic expression issue... in QlikView

expression issue...

Fri, 20 Jan 2012 09:29:17 GMT

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 — Fri, 20 Jan 2012 09:42:51 GMT

You can do the same in Qlikview

Assuming that text is the variable of a Input Box

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

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.

Mon, 23 Jan 2012 04:33:34 GMT

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 — Mon, 23 Jan 2012 05:00:11 GMT

You can do this by using set analysis.

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

Hope this your need

Celambarasan