topic Re: Current and Previous Quarter calculations in QlikView

Current and Previous Quarter calculations

Anonymous — Mon, 28 Aug 2017 15:36:35 GMT

Hi all,

I am creating a Quarter field with the following script:

'Q' & ceil(right([Acc_Calendar.Acc Period],2)/3) as Quarter

How do i then create a vCurrentQuarter and vPreviousQuarter ?

Thanks in advance

Re: Current and Previous Quarter calculations

effinty2112 — Mon, 28 Aug 2017 15:45:40 GMT

Hi Kieron,

Consider a separate numeric QuarterID field such as

ceil(right([Acc_Calendar.Acc Period],2)/3) as QuarterID

or you can try defining your quarter as a Dual:

Dual('Q' & ceil(right([Acc_Calendar.Acc Period],2)/3) , ceil(right([Acc_Calendar.Acc Period],2)/3) ) as Quarter

Cheers

Andrew

Re: Current and Previous Quarter calculations

Anonymous — Tue, 29 Aug 2017 13:21:30 GMT

Thanks Andrew,

That gives me a numeric value for each quarter, what is the logic then to get current quarter (or previous quarter). To get Current week i have used: let vCurrent_week = num(week(today()), '00');

To get current year week i have used: let vCurrent_yearweek = weekyear(today()) & num(week(today()), '00');

But i'm confused about current quarter.

Thanks,

Kieron

Re: Current and Previous Quarter calculations

effinty2112 — Tue, 29 Aug 2017 13:27:38 GMT

Hi Keiron,

In the UI $(=max(QuarterID)) will give the current QuarterID according to the selections and $(=-1+max(QuarterID)) will give the previous.

Cheers

Andrew

Re: Current and Previous Quarter calculations

Anonymous — Tue, 29 Aug 2017 13:29:09 GMT

You can try below one

vCurrent_Quarter= Year={"$(=GetFieldSelections(Quarter))"}

vPrevious_Quarter = Year={"$(=GetFieldSelections(Quarter)-1)"}

sum({<$(=vCurrent_Quarterr)>}Sales)

sum({<$(=vvPrevious_Quarter)>}Sales)

Re: Current and Previous Quarter calculations

Anonymous — Tue, 29 Aug 2017 13:29:59 GMT

You can try below one

vCurrent_Quarter= Quarter={"$(=GetFieldSelections(Quarter))"}

vPrevious_Quarter = Quarter={"$(=GetFieldSelections(Quarter)-1)"}

sum({<$(=vCurrent_Quarterr)>}Sales)

sum({<$(=vvPrevious_Quarter)>}Sales)

Re: Current and Previous Quarter calculations

Anonymous — Tue, 29 Aug 2017 13:51:08 GMT

Hi devendarlakkyreddy‌ where should i try create those? in the script editor or in my calculation ?

Thanks,

Kieron

Re: Current and Previous Quarter calculations

Anonymous — Tue, 29 Aug 2017 13:53:43 GMT

by using Quarter field in the front end create a variable , then use calculation in the chart