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?