6 Replies Latest reply: Nov 10, 2016 3:55 AM by jagan mohan rao appala RSS

    Date range is not working properly

    Mohammad Sarif

      Hi All,

      My source is excel with only one date field. I need to implement From Date and To Date in dashboard.

      As per data :

      Count(CallTypeID) = 369 in 14th Oct

      Count(CallTypeID) = 1 in 15th Oct

      Now in Qlik Dashboard if I select :

      From Date= 14th and To Date = 14th, then count = 369

      From Date= 14th and To Date = 15th, then count = 370 as expected. But if I select

      From Date= 15th and To Date = 15th, then count = 370, however it should be 1.

      My expression is below:

      Count({$<NewDate={'>=$(=$(v_FromDate))'},NewDate={'<=$(=$(v_ToDate))'}>}[CallTypeID]).

      Please suggest.

      Thanks,

      Sarif