Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

YTD sales quarter wise

Hi All,

I have two years 2016 and 2017 sales. We are using master calendar. 2016 quarter wise sales to be compared with 2017 YTD sales quarter wise.

i.e

Q12016 is (Jan feb Mar), Q22016 (Apr May Jun), Q32016 (Jul Aug Sep) and Q42016 (Oct Nov Dec) of 2016.

But

Q12017 is Jan feb Mar, Q22017 (Jan feb Mar Apr May Jun), Q32017 (Jan feb Mar Apr May Jun Jul Aug Sep) and Q42017 is (Jan feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec) of 2017.


Regards,

Krishna

2 Replies
Highlighted
Champion II
Champion II

Re: YTD sales quarter wise

refer this post,

Calculating rolling n-period totals, averages or other aggregations

the same concept can be used on the Quarters dimension

Highlighted
Contributor III
Contributor III

Re: YTD sales quarter wise

Hi Vineeth,

This comparison required to be on stack bar chart. Below is sample image which was created in Ms office excel.

Sample Image.png