sum import without year and month selected

Wed, 26 Jan 2011 10:15:14 GMT

Hi to all community!!

Since yesterday I,m thinking how to do a sum. It seems easy, but it doesn´t for me. I´ve got a table with year and month fields, and every report I do I configure sum function to see data whatever which month or year is selected. It works fine.

But now I want to see more detail, and I have an analytic table. I´ve linked these table between a relation I create by myself (company+account+year+month). I did that because I wanted to do a conditional sum (with variables) of analytic table, but the results aren´t right if I select year or month.

The expresion i´m using is:

SUM

({$<MONTH={'<=$(=MONTH)'}, YEAR={'<=$(=YEAR)'} IMP_DIARIO)

If I select year 2010 and month 11 it shows me only SUM of 2008, 2009 and 2010, but never including december 2008 and 2009.

I hope I explain myself and thank you for your answers.

Fiber9906

topic sum import without year and month selected in QlikView

sum import without year and month selected