1 Reply Latest reply: Sep 14, 2018 1:35 PM by Felip Drechsler RSS

    Subtracte dates of different categories in chart

    Sophie Tielens

      Dear Qlik users,

       

       

      I would like to know how I can subtract 2 dates of 2 different categories in Qliksense:

       

      End_date (closing store) - Start_date (opening store)

       

      To see how long the store was open. Closing store and opening store are registered activities and the date is given in year, month, day ad time.

       

      How do I formulate this in a chart formula (or KPI chart)?

       

      Thank you in advance!!!