topic Re: Assign sum to a varaiable in QlikView

Assign sum to a varaiable

Anonymous — Thu, 21 Apr 2016 15:35:21 GMT

Hi,

What is wrong with the following:

Let vDrugs = Sum(if(Medication_Drug1>0,Medication_Drug1,0)) + Sum(if(Medication_Drug2>0,Medication_Drug2,0))

sunny_talwar — Thu, 21 Apr 2016 15:40:07 GMT

Are you using this in the script or the intention is to use this on the front end? And what kind of error are you getting?

Anonymous — Thu, 21 Apr 2016 15:45:41 GMT

The error – “error in script” (when I reload.

The intent is to sum the two columns (numeric/integer), and add them to create vDrugs. Then, present the value of vDrugs on one of the sheets.

syukyo_zhu — Thu, 21 Apr 2016 15:51:04 GMT

try like this

Let vDrugs = 'Sum(if(Medication_Drug1>0,Medication_Drug1,0)) + Sum(if(Medication_Drug2>0,Medication_Drug2,0))';