topic Re: Merge two working functions, fail in QlikView

Merge two working functions, fail

Thu, 07 May 2015 09:01:04 GMT

Hi,

Im trying to replace "AMOUNT" in my first expression with the IF statement. But I cannot make it work.

They both work properly when trying them separately. What am I missing here? How would you merge the two?

Kind Regards,

Olle

SUM({<[FLOW TYPE]= {'XXX'}>}AMOUNT )

SUM(IF([FLOW EFFECTIVE DATE]<DATE and [FLOW MATURITY DATE]> DATE,AMOUNT))

sunny_talwar — Thu, 07 May 2015 09:04:10 GMT

What is the combined version that you are trying?

Gysbert_Wassenaar — Thu, 07 May 2015 09:05:46 GMT

SUM({<[FLOW TYPE]= {'XXX'}>} IF([FLOW EFFECTIVE DATE]<DATE and [FLOW MATURITY DATE]> DATE,AMOUNT))