Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Data of the previous month to the selected month

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
Highlighted

Re: Data of the previous month to the selected month

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

Highlighted
Contributor III
Contributor III

Re: Data of the previous month to the selected month

yes

Highlighted

Re: Data of the previous month to the selected month

Check this for text box object

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

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Data of the previous month to the selected month

Thanks

You are the best.