1 Reply Latest reply: Jul 11, 2016 6:47 AM by Marcus Sommer RSS

    Date Range use in a function/formaula

    Rahul Krishan Goyal

      HI,

       

      I AM NEW TO QLIK.

       

      SOMEONE PLEASE HELP.

       

      I WANT TO APPLY DATE RANGE (FROM DATE - TO DATE, i.e. 11/7/2016 - 15/07/2016) FILTER FOR GRAPHS, KPIs AND TABLES FOR "SDATE" FIELD AVAILABLE IN A TABLE.

       

      I AM CALCULATING TIME DIFFERENCE (MAX EDATE AND MIN EDATE IN A FORMULA).

       

      THE FROM DATE AND TO DATE WILL BE TWO FILTERS HAVING SAME SDATE AS DIMENSION.

       

      WHENEVER A USER SELECTS A DATE RANGE, THE TIME DIFFERENCE FORMULA TO BE CALCULATED FOR THE SELECTED DATES.

       

      PL. HELP ASAP.

       

      THANK YOU,

       

      RAHUL