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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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