topic IF Statement and Set Analysis in QlikView

IF Statement and Set Analysis

Anonymous — Thu, 10 Mar 2016 16:04:20 GMT

Hi All,

I need some help with IF statement and Set Analysis.

I want below expression with exclusion(1) to incorporate with the bottom expression (2). Both of these expressions works, I just added a variable for user input on the bottom expression(2).

(1)

XIRR({<Company-={'*XYZ.*'},[Type]-={'Income:','Expense:'}>} Amount,[Date])

(2)

XIRR(If(Date = Makedate(2015, 12, 31), Amount - Fabs(vIRR), Amount),Date)

Any input will greately appreciated!

Many Thanks,

Frank

Re: IF Statement and Set Analysis

Gysbert_Wassenaar — Thu, 10 Mar 2016 16:11:16 GMT

XIRR({<Company-={'*XYZ.*'},[Type]-={'Income:','Expense:'}>} If(Date = Makedate(2015, 12, 31), Amount - Fabs(vIRR), Amount),Date)

Re: IF Statement and Set Analysis

Anonymous — Thu, 10 Mar 2016 16:52:47 GMT

Hi Gysbert,

it's not working. Below is what I have. I replace the makedate to '12/31/2015'.

=XIRR({<Company-={'*XYZ*'},[Trans Type]-={'Income: Other','Expense: Other, Miscellaneous'}, [Date]-={"$(=vMinDate)"}>}If([Date]='12/31/2015',([Amount] + $(vIRR)), [Amount]),[Date])