1 Reply Latest reply: Apr 3, 2017 6:21 AM by Manish Kachhia RSS

    Calculate variance

    Sunilkumar Yadav

      Hi ,

       

      I am new to the qlik.

       

      My requirement is i have to calculate the variance on the DeliveryStartDateTime and store dimension i.e.

      count(orderid)/count(orderid) where DeliveryStartDateTime= DeliveryStartDateTime - 7

       

      but i am not able to handle this in set analysis can any one help on this.

      Should i handle this at script level or at expression level?

      i have tried below expression .


      and can we handle this using AS-of Table and how?

       

      count(orderid) / count({1<DeliveryStartDateTime={"$(=date(DeliveryStartDateTime-7,'DD-MM-YYYY'))"}>}orderId)