1 Reply Latest reply: Nov 14, 2015 6:25 AM by Stefan Wühl RSS

    Set Analysis and problem dates

    eugeni baque

      Edit by community team member:

      Post translated by google translate.

      Please post in English unless in a specific language section. Thank you.

       

      ---

       

      Hello,

       

      I have a tablet loaded Excel in which there is a date. The charge as it is to QLIK without Date or Date #. In the same table is the Amount field.

      I have a vHoy variable, defined as Round (Today ()) in QLIK.

      I want to add the amounts vHoy dated before.

      SET ANALYSIS use because I need more data later restrict, why not use SUM IF.

      My expression is sum ({<Date. = {"<$ (VHoy)"}>} amount) can not be simpler.

      It always gives me 0.

      I worked so far changed Excel. In Excel if I sack Date format Date and let in General, the cell contains a number, which is not a text.

      Dons anyone know I'm wrong?

      Thank you.