4 Replies Latest reply: Mar 9, 2016 3:37 AM by Sunny Talwar RSS

    Qty Count

    Hassan Sajjad

      Hi there,

       

      I have 4 sheets in a Test Excel file (file attached). All are having same column called 'Qty'. If I use sum() function it counts qty from all 4 sheets.


      My confusions are:

      1- How to sum up Qty column total separately for each individual excel sheet?

      2- This expression works for current date sum but again it sums up all 4 excel sheets: sum({1 <Date={"$(=today())"}>} total Qty).

      3- How to count total Qty excluding today's Qty again for separate excel sheet?

       

      Please assist since I am new to Qlik Sense scripting.

       

      Regards,
      Hassan