Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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?

Tags (3)
1 Reply
darkhorse
Valued Contributor

Re: Show data in polygonmap from last 7 days

Hello,

Try sum(if(,) ) structure.

BR

Serhan