topic Re: Current Quarter vs Previous Quarter in QlikView

Current Quarter vs Previous Quarter

JoeyPob1214 — Wed, 25 Nov 2020 16:16:04 GMT

I want to show the previous Quarter values, current Quarter Values and its difference in my table, but the problem is when the Current Quarter is 20201 (1Q2020) and the previous Quarter is 20194 (4Q2019) it doesn't show any values but when the current Quarter is 20202 (2Q2020) and the previous Quarter is 20201 (1Q2020). The data shows itrs value.

First thing I think of the issue is the calendar.

I hope you can help me guys.

Thanks!

Re: Current Quarter vs Previous Quarter

thi_pham — Mon, 22 Jun 2020 10:11:36 GMT

Some advises, hope it helps:

- Check format of date field (data load editor or data management)

- Use autocalendar

- Use quartersAgo like:
+ sum({$<[DateCode.autoCalendar.QuartersAgo]={0}>} fieldname) -> current Quarter
+ sum({$<[DateCode.autoCalendar.QuartersAgo]={1}>} fieldname) -> last Quarter
...

Re: Current Quarter vs Previous Quarter

JoeyPob1214 — Mon, 22 Jun 2020 10:54:48 GMT

what do you mean by the date code and QuartersAgo? Are these functions in QlikView?

Already had the autocalendar in code.

Re: Current Quarter vs Previous Quarter

thi_pham — Mon, 22 Jun 2020 11:05:43 GMT

Sorry, my bad, I just thought your question is on QLik sense.

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Assets/date-time-fields.htm

QuartersAgo is a field of autocalendar on QLik sense (not sure it's available on Qlikview or not)

DateCode is just the name of Date field.

Re: Current Quarter vs Previous Quarter

JoeyPob1214 — Mon, 22 Jun 2020 11:08:48 GMT

I think this is not applicable with Qlikview

Re: Current Quarter vs Previous Quarter

Brett_Bleess — Wed, 08 Jul 2020 18:17:04 GMT

Best I have is the following Design Blog post that may be of some help to you:

https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927

Regards,
Brett