Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Regarding Quarter comparision

Hello Friends,

I appreciate your time.

I am looking for some help with quarter comparison.

I need to compare current quarter sales vs last year quarter(Same period) . Could you kindly share your ideas!

Thank you!

Kiruthiga

2 Replies
neelamsaroha157
Valued Contributor II

Re: Regarding Quarter comparision

You can create two variables fro your current & previous Quarter and use them in set analysis.

Assuming that your Quarter Field format is [Quarter Year]

CurrQuarter  = quartername(Max(Date))

PreQuarter =   QuarterName(quartername(Max(Date)), -1)

neelamsaroha157
Valued Contributor II

Re: Regarding Quarter comparision

Sorry

PreQuarter =   QuarterName(quartername(Max(Date)), -1)  will give you last Quarter.

Change it to -- PreQuarter =   QuarterName(quartername(Max(Date)), -4)