Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum import without year and month selected

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



0 Replies