Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

Pull the value based on max (date) from each month with the previous value.

Hi Experts,

I have the data let say

Table1:

Date                CP
1.01.201825
3.01.201812
17.01.2018    23
4.02.2018      43
13.02.2018   54
15.03.2018 13
16.04.2018   44

 

and I need the output

Date

Current CP

(Based on Max date in every month)

Previous CP

(Just previous value to current CP)

Difference (Current CP - Previous CP)
17.01.2018    231211
13.02.2018   544311
15.03.2018 1354-41
16.04.2018   441331


where i have to get Current CP based on Max date present in each month and the previous CP will be just previous value of Current CP value. How can I achieve this.

Please help if you can.

Thanks in advance.

1 Reply
MVP & Luminary
MVP & Luminary

Re: Pull the value based on max (date) from each month with the previous value.

See attached qvw


talk is cheap, supply exceeds demand