topic Re: How i can do this ... ? in QlikView

How i can do this ... ?

Fri, 07 Dec 2012 19:33:36 GMT

How i can do this in set analysis????

if(AmortType='N',sum(if((Date(vToday) - Date(if(DateType='C',RefDate,DueDate)))>360,Debit-Credit)),

sum(if((Date(vToday) - Date(if(DateType='C',RefDate,DueDate)))>360,Debit-Credit)))

please help me.

Regards

Fernan Gonzalez

Re: How i can do this ... ?

Gysbert_Wassenaar — Fri, 07 Dec 2012 20:02:15 GMT

You can't do this with set analysis expressions as far as I know. Set analysis calculates sets to operate on. That's not what you're doing here. You use if statements to pick which sum expression to use and which field to use in comparisons. Set analysis can't help you with that. You need the if statements for that.

Re: How i can do this ... ?

Fri, 07 Dec 2012 20:24:39 GMT

thanks