Qlik Sense App Development

New Contributor III

Qlik Sense - Sum This Month vs Last Month same date

Dear Community,

How to sum this month vs last month same date?

Records:

Date(DD-MM-YYYY)  Value

01-10-2017              5

02-10-2017              50

03-10-2017              17

04-10-2017              30(Should exclude this record)

01-11-2017              15

02-11-2017              30

03-11-2017              2

Expected Result:

Month Year    Value

Oct' 17          32

Nov' 17          47

32 = 5+ 50 + 17

47 = 15 + 30 + 2

I tired the Expression:

1 Solution

Accepted Solutions
Valued Contributor

Re: Qlik Sense - Sum This Month vs Last Month same date

I imagine you meant 73 instead of 32 right?

I'm struggling to get this Set Analysis working, please take a look. Also, what defines that 3/11/17?

I created YEARMONTH during the script

5 Replies
Valued Contributor

Re: Qlik Sense - Sum This Month vs Last Month same date

Hi,

Maybe this one?

New Contributor III

Re: Qlik Sense - Sum This Month vs Last Month same date

Return 0 value.

Valued Contributor

Re: Qlik Sense - Sum This Month vs Last Month same date

I imagine you meant 73 instead of 32 right?

I'm struggling to get this Set Analysis working, please take a look. Also, what defines that 3/11/17?

I created YEARMONTH during the script

Valued Contributor

Re: Qlik Sense - Sum This Month vs Last Month same date

I meant 72

New Contributor III

Re: Qlik Sense - Sum This Month vs Last Month same date

Thanks it is working