# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Contributor

## if (amount is negative) then sum(negative amounts)

Hello,

I hope you will find the answer for me, because I couldnt.

How can I realise this logic/formula with set analysis?

if (amount is negative) then sum(negative amounts).

I've a column with numbers(Field name is Amount). Some of them are positive and some negative numbers. And I need to get only sum of negative numbers from Amount column. Is it possible with set analysis or in defferent way?

Best Regards,

~Sergejs

1 Solution

Accepted Solutions
Not applicable

## if (amount is negative) then sum(negative amounts)

Hi,

You can try like this Sum(if(Column_Name)<0,Column_Name).Same you can get in Set Analysis

-Jai

5 Replies
Not applicable

## if (amount is negative) then sum(negative amounts)

Hi,

You can try like this Sum(if(Column_Name)<0,Column_Name).Same you can get in Set Analysis

-Jai

Contributor

## if (amount is negative) then sum(negative amounts)

Thanks Jai,

Thats easy and correct. I should take a rest.

~Sergejs

Contributor III

## Re: if (amount is negative) then sum(negative amounts)

HI,

PFA. Hope this is of some help. Jai is also telling the same concept.

Contributor

## if (amount is negative) then sum(negative amounts)

Have you got any example how to realise this with set analysis as well?

Best Regards,

~Sergejs

Contributor

Thanks Sharma,