Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
LEGION
Contributor II
Contributor II

Sum Sales QTY by month

Hello,

 

I need some help please, im trying to use the following formula to SUM up Sales Qty by rolling month,

 

(SUM({<TCODE={'IN'}, TXDATE={">=$(=date(addmonths(today(),-1)))"}>} QUANTITY))

What i want to see is my Total Sales Qty for Last month, then i will use the same formula to total 2 months ago, then 3 months ago.... problem is its not working 😞

 

TCODE = SALES TYPE

IN = INVOICES

TXDATE = TRANACTION DATE

 

Labels (4)
1 Solution

Accepted Solutions
kashyap311996101

Hi 

Use RangeSum() Function 

or

 PFA

you can change directly in measure settings

Thanks

Thanks and Regards
Kashyap.R

View solution in original post

1 Reply
kashyap311996101

Hi 

Use RangeSum() Function 

or

 PFA

you can change directly in measure settings

Thanks

Thanks and Regards
Kashyap.R