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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write expression on sum of capital ( Eg: sum of 2016 Nov to 2018 April)

I have data from Nov 2016 to April 2018. can any one share how to write expression for sum.

7 Replies
Frank_Hartmann
Master II
Master II

try like that:

Sum({<Date={'>=$(=MonthStart(makedate(2016,11))) <=$(=MonthStart(makedate(2018,4)))'}>} Sales)

hope that helps

sunny_talwar

Not sure I understand, do you want this? Sum(Capital)?? If this is not what you want, would you be able to expand on your requirements

MK_QSL
MVP
MVP

=SUM(Sales)

or

SUM(Value)

Not applicable
Author

Its working but team says its hard code

Not applicable
Author

want to sum the Finance Amount for the period of Nov 2016 to April 2018

sunny_talwar

What is the reason for picking this date range?

Not applicable
Author

need to show the sum of Finance Amount in KPI