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
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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: 
Ramu_i
Creator II
Creator II
‎2023-10-12 09:48 PM

Latest Month, Prev Month, Latest Quarter, Previous Quarter, TTM, YTD, Latest Year and Prev Year

Hi All,

Product ID City Pin YTD TTM Y:2021 Y: 2022 Q: 2021 Q3 Q: 2021 Q4 Q: 2022 Q1 Q: 2022 Q2 Q: 2022 Q3 Q: 2022 Q4 M: 2021-08 M:2021-09
Apple 10001 blr 560100 200 400 500 700 200 400 500 700 200 400 500 700
Banana 10002 hyd 260540 300 300 600 750 300 300 600 750 300 300 600 750

 

Based on the data how to find the 

Latest Month, Prev Month, Latest Quarter, Previous Quarter, TTM, YTD, Latest Year and Prev Year

 

 

Thanks Advance.

Ram

 

338 Views
0 Likes
1 Reply
vikasmahajan
MVP
MVP
‎2023-10-13 02:49 AM

Hi 

Refer this document you can implement logic using demo app attached.

https://community.qlik.com/t5/Member-Articles/As-of-Table-with-YTD-MTD-QTD-amp-Calculation-of-Rollin...

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
297 Views
0 Likes