Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harson
Contributor III
Contributor III

Data of the previous month to the selected month

Hi,

Can somebody help me please

I would like to have the data of the previous month to the selected month using SetAnalysis.

Here are the data I have

Capture.JPG

I'd like to have if I select 04/01/2018 or 01/01/2018 the Sum of Value_FD where Month = Dec-2018 (45) and so on... If I select 25/12/2017 or 03/12/2017 or 21/12/2017 I'll have the Sum of Value_FD where Month = Nov-2018 (61)



Thanks in advance


Part of data :


DATA :

LOAD Date(FULL_DATE) as DATE,

Value_FD

INLINE [

    FULL_DATE, Value_FD

    01/01/2018, 5

    04/01/2018, 5

    25/12/2017, 10

    03/12/2017, 17

    21/12/2017, 18

    02/11/2017, 56

    05/11/2017, 5

];

1 Solution

Accepted Solutions
sunny_talwar

Check this for text box object

=Sum({<DATE = {"$(='>=' & Date(MonthStart(Max(DATE), -1)) & '<' & Date(MonthStart(Max(DATE))))"}>}Value_FD)

View solution in original post

4 Replies
sunny_talwar

Where do you want to show this value in a text box object?

harson
Contributor III
Contributor III
Author

yes

sunny_talwar

Check this for text box object

=Sum({<DATE = {"$(='>=' & Date(MonthStart(Max(DATE), -1)) & '<' & Date(MonthStart(Max(DATE))))"}>}Value_FD)

harson
Contributor III
Contributor III
Author

Thanks

You are the best.