Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
Creator
Creator
‎2019-10-23 03:39 AM

LAST MONTH VALUE

Dear All I Select year 2019 and month of September and i want to get a value of 2019 august value please help sagara
658 Views
0 Likes
2 Replies
sudhirpkuwar
Partner - Creator II
Partner - Creator II
‎2019-10-23 07:09 AM

Try Addmonths()

For eg. Addmonths(max(<Date Field>),-1) will give you previous of month selected

634 Views
0 Likes
Brett_Bleess
Former Employee
Former Employee
‎2019-10-31 02:23 PM

The following Design Blog links may provide some further ideas too:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
607 Views
0 Likes