New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION

Who Me Too'd this solution

dplr-rn
Partner - Master III
Partner - Master III

Few Steps
1- create a master calendar if you dont have one
https://qlikviewcookbook.com/2015/05/better-calendar-scripts/

2- add a column to your master calendar for quarter year 

e.g. 

'Q' & ceil(month(TempDate) / 3)&'-' & Year(TempDate) AS QuarterYear,

3 - 2 variables to identify current quarter and previous quarter

e.g.

vCurrentQuarter = 'Q' & ceil(month(today()) / 3)&'-' & Year(today())

vPreviousQuarter = 'Q' & ceil(month(addMonths(today(),-3)) / 3)&'-' & Year(addMonths(today(),-3))

4- use the variables in your expressions

e.g.

sum({<QuarterYear={$(vCurrentQuarter)}>}Sales)

sum({<QuarterYear={$(vPreviousQuarter)}>}Sales)

View solution in original post

Who Me Too'd this solution