Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
LEGION
Contributor
Contributor

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 (5)
1 Solution

Accepted Solutions
kashyap
Partner
Partner

Hi 

Use RangeSum() Function 

or

 PFA

you can change directly in measure settings

Thanks

View solution in original post

1 Reply
kashyap
Partner
Partner

Hi 

Use RangeSum() Function 

or

 PFA

you can change directly in measure settings

Thanks

View solution in original post