topic sum() in listbox in QlikView

sum() in listbox

Mon, 28 Mar 2016 07:00:01 GMT

hi everyone.. i am new to qlikview, working on my own.

i have a n issue that i cant understand. i am having a column Amount . i created a list box and given this field and in expression i wrote

sum(Amount), and in another listbox i wrote..sum({$}Amount).

i cant understand the difference between those two listboxes..

anyone help please..

Re: sum() in listbox

sunny_talwar — Mon, 28 Mar 2016 10:13:27 GMT

Sum(Amount) essentially same thing as Sum({$} Amount) unless you happen to have your list box in alternate state. $ explicitly points it to be in the inherited state.

Re: sum() in listbox

Chanty4u — Mon, 28 Mar 2016 10:15:29 GMT

as sunny.

Variables

Re: sum() in listbox

amit_saini — Mon, 28 Mar 2016 10:16:49 GMT

Hi ,

Hope this will help u to understand set analysis.

Thanks

Re: sum() in listbox

Mon, 28 Mar 2016 10:25:13 GMT

thank you very much.. those all are very helpful..