Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.?
Hi
You can do this by using set analysis.
Sum({<fieldName={'$(variable)'}>} fieldname)
Hope this your need
Celambarasan
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.
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....
Hi
You can do this by using set analysis.
Sum({<fieldName={'$(variable)'}>} fieldname)
Hope this your need
Celambarasan