topic Help on SetAnalysis in QlikView

Help on SetAnalysis

Wed, 01 Sep 2010 09:47:08 GMT

HI All,

I Want to get an Outstanding Amt (Sum(Amt)).I have data which starts from 200901.

So now for Eg: :when i click 201002 (Feb'2010) i should get sum of outstanding from 2009-01 to 201002.

I am using the below code its not working

=num(sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} Amt), '#,##0;($#,##0)')

CAn Any one please help me.

Thanks in Advance

Regards,

Ankit

Help on SetAnalysis

Wed, 01 Sep 2010 17:03:08 GMT

Hi,

I think that the problem in your formula is int month part, You can try like this:

NUM(SUM({$<Year = {$(=max(Year))}, Month = {"<=$(=max(Month))"}>} Amt), '#,##0;($#,##0)')

Tell us later if it works

Regards

Orlando

Help on SetAnalysis

Fri, 03 Sep 2010 11:44:33 GMT

No this is not working...

Please any one can help on this.....

Help on SetAnalysis

Fri, 03 Sep 2010 11:44:39 GMT

No this is not working...

Please any one can help on this.....

Help on SetAnalysis

Miguel_Angel_Baeyens — Fri, 03 Sep 2010 12:30:02 GMT

Hi,

You may have a Date field, that will change depending on the selection for Year and Month field. So basically, you need in your set analysis all those records which date started one year ago. The idea then would be

=num(sum({$< Date = {">=$(=AddYears(DateField, -1))"} >} Amt), '#,##0;($#,##0)')

Hope this helps!