Comparing two date ranges

benoitgochel — Tue, 20 Jun 2017 08:11:12 GMT

Hi evrebody,

I would like to implement a table which compare two ranges of dates previously selected with a date range picker.

I already have a tab with those informations :

The Sales P-1 and Sales P are defined with a simple combo box filter (YTD, 0-12/12-24, etc.) with the held of a variable.

num(Sum({<$($(vLVarP1)),$(vSetSales)>}[$(vFieldCurrency)]),'$(vNumFormatKPI)')

Is my variable used for Sales P.

The vSetSales is my set analysis with the sum of my sales, then the currency etc.

For the period, the vLVarP1 is important. It's this one that is linked to another set of variables, dynamically changed with the combo box selection. For instance, if the 0-12/12-24 is selected the value

Fiscal_Year,PeriodID_Now={">$(=$(vMaxMOPeriodIDNow)-24)<=$(=$(vMaxMOPeriodIDNow)-12)"},FiscalQuarter,Date,Year,Month,Period,Fiscal_Month,FiscalNMonth,FiscalPeriod,Date_Now,Date_Now_Name,Date_Name,Fiscal_Year_Text,Cal_Period_Now

is set to the variable.

Now, I would to change this logic, and be able to chose with two date range pickers the two periods that I compare.

Do you think It's possible and can someone please explain me how to do it?

Thank you in advance.

topic Comparing two date ranges in App Development

Comparing two date ranges