Comparing semester selected vs previous

JaviValtu — Thu, 05 Mar 2020 09:44:22 GMT

Hi, I need to display data comparing similar periods against their previous period (Month, Quarter and Semester). The problem is that when user select the current period (unclosed period) we should compare it with the same number of days in the previous period. I applied this logic with Month an Quarter using MonthStart and QuarterStart functions, and it works:

InMonthToDate([Day], Today(), 0) * -1 AS [CurMTDFlag], //Current Month Flag

if ([Day]>=date(MonthStart(Today(), -1),'DD/MM/YYYY') and [Day]<=date(MonthStart(Today(), -1)+(Today()-MonthStart(Today(), 0)),'DD/MM/YYYY'),1,0) as [PrMTDFlag], //Prior Month Flag

InQuarterToDate([Day], Today(), 0) * -1 AS [CurQTDFlag], //Current Quarter Flag

if ([Day]>=date(QuarterStart(Today(), -1),'DD/MM/YYYY') and [Day]<=date(QuarterStart(Today(), -1)+(Today()-QuarterStart(Today(), 0)),'DD/MM/YYYY'),1,0) as [PrQTDFlag], // Prior Quarter Flag

if (InMonths(6,[Day], Today(),0), 1, 0) AS [CurHYTDFlag] //Current Semester Flag

Now, I have this problem:

- How can I apply the same logic for previous SEMESTER (Always considering Semester 1 as Jan-Jun and Semester 2 as Jul-Dec)?

Thanks a lot!

Re: Comparing semester selected vs previous

samazian — Thu, 05 Mar 2020 09:45:59 GMT

I have the same problem!! In my case I need to be able to switch between Months (comparing the selected month with its previous), does anyone know any solution?

Thanks!

Re: Comparing semester selected vs previous

Sue_Macaluso — Thu, 05 Mar 2020 16:18:40 GMT

@JaviValtu Are you using QlikView or Sense? I would like to move this into the correct product forum. Thank you.

topic Re: Comparing semester selected vs previous in Water Cooler

Comparing semester selected vs previous

Re: Comparing semester selected vs previous

Re: Comparing semester selected vs previous