1 Reply Latest reply: Jan 12, 2015 9:21 AM by Serhan Celebi RSS

    Show data in polygonmap from last 7 days

      In Qlik Sense I've a polygonmap .

      The layer is the isocountrycode and the mesaure should be a function where I like to SUM a field, but only for the last 7 days. In case there is no data, I like to show 10.

      I'm having a csv with a datefield e.g. "27.10.2014 11:29". I tried different ways in the function for mesaure field like:

      if(date(time2, 'YY-MM-DD') > date(now()-7, 'YY-MM-DD'), sum([callid]), 10).

       

      Could you please help me, or did I understand something completly wrong and it is not possible?