topic Re: sum-if-function in combination with a where-function in QlikView

sum-if-function in combination with a where-function

Anonymous — Fri, 01 Mar 2013 16:18:26 GMT

Hi all,

I want to use the sum-if-function in combination with a where-function. Is this possible?

The problem is that I want to use the where-function on another field.

My solution doesnt work:

sum(rangeonly(if(field1>6000 and field1<6999,field2)), where (field3) like 'd%') as field4

Thank you for your answers!

Re: sum-if-function in combination with a where-function

Fri, 01 Mar 2013 16:23:25 GMT

I would use set analysis

http://community.qlik.com/servlet/JiveServlet/previewBody/1867-102-1-1858/QlikLearn-Set-Analysis-Presentation.pdf

is a good reference

Re: sum-if-function in combination with a where-function

MEllinghausen — Fri, 01 Mar 2013 16:23:31 GMT

you want create filed4 in the script?

Re: sum-if-function in combination with a where-function

Anonymous — Fri, 01 Mar 2013 16:26:18 GMT

Yes

Re: sum-if-function in combination with a where-function

MEllinghausen — Fri, 01 Mar 2013 16:40:57 GMT

I dont know what you want to sum, if you want in field 4 the value from filed2 if field 1 >6000 - <6999 and field3 like'd%'

you can do it so

if(field1>6000 and field1<69999 ,field2) as field4 from ...... where field3 like 'd*';

Re: sum-if-function in combination with a where-function

Anonymous — Fri, 01 Mar 2013 16:58:06 GMT

There is still a mistake in my skript, I don't recognize.

Yes, I want to sum the vaule of field2 in field4. What do you mean with from ...Here is my skript, but with the original names - I hope this is not a problem:

Spesen_Jahr:

Load

Spesen_Projekt_Jahr,

sum(rangeonly(if(Buchungs_Konto>6000 and Buchungs_Konto<6999,Umsatz_Soll))

) as Eregbnis_Spesen_Projekt_Jahr where MAID like 'd*'

Resident Primanota

group by Spesen_Projekt_Jahr;