Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zekazak
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?

Thank you in advance!

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

zekazak
Contributor

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

Thanks Jai,

Thats easy and correct. I should take a rest.

~Sergejs

montubhardwaj
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.

zekazak
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

zekazak
Contributor

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

Thanks Sharma,

Nice example and very helpful.

Best Regards,

Community Browser