topic Re: sum in Set Analysis in QlikView

sum in Set Analysis

bilionut — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to sum all the values with Satus = 'Active' and those with Status='Sold' and IDFact not NULL

LOAD *

Inline [

Dim,IDFact,Value,Status

AA,1,10,Active

BB,,20,Active

CC,,30,Sold

DD,4,40,Sold

];

How do I do that in Set Analysis?

Tanks,

vhespinog — Sat, 03 Jun 2017 18:05:46 GMT

May be something like this

=sum({$<Status = {'Active','Sold'}, idFact ={"=len(trim(IDFact))>0"} >}Value)

vinieme12 — Sat, 03 Jun 2017 18:31:03 GMT

References

bilionut — Sat, 03 Jun 2017 19:07:16 GMT

Your expression brings all the values. I need to exclude only those values that have Status=Sold and IDfact null

The condition must be something like that:

(Status = {'Active'} ) or (Status='Sold' and IDFact not NULL)

In the end I found that this works

sum({<IDFact={"=len(trim(IDFact))>0"}> * <Status={'Sold'}>+<Status={'Active'}>} Value)

Anonymous — Mon, 23 Jul 2018 04:03:12 GMT

Hi,

It is possible to be something like below

sum({$<Status = {'Active','Sold'}, idFact ={"=len(trim(IDFact))>0 and len(trim(IDFact))<5"} >}Value)

Best Regards,

Louis