topic Re: How to Sum in script with IF in QlikView

How to Sum in script with IF

Anonymous — Mon, 15 Feb 2016 10:43:37 GMT

Hiya All

I am trying to Sum a Field base don IF can you guys help

if transtype - 1 Sum (Transtype) as T1

if transtype - 1 Count (Transtype) as T2

Can anyone help please?

Thanks

PrashantSangle — Mon, 15 Feb 2016 10:46:04 GMT

Hi,

Need more explanation..

Provide some data..

Regards

sunny_talwar — Mon, 15 Feb 2016 10:46:18 GMT

What is the condition here? May be something like this:

Sum(If(Condition = Something, Transtype)) as T1,

Count(If(Condition = Something, Transtype)) as T1,

Anonymous — Mon, 15 Feb 2016 10:46:58 GMT

try like this?

If(transtype=1, sum(transtype)) as T1

If(transtype=1, Count(transtype)) as T1

Mark_Little — Mon, 15 Feb 2016 10:59:11 GMT

Hi,

If you are doing this in script it will be some from of aggregation. something like

Load

...

SUM(transtype) as T1,

Count(transtype) as T2

Resident 'Your Table'

Where transtype = 1

Group by FIELD;

Mark

sujeetsingh — Mon, 15 Feb 2016 11:07:16 GMT

Add column

Sum(If(Condition = Something, Transtype)) as T1,

Count(If(Condition = Something, Transtype)) as T1,

While resident load in your script.