Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gustavobelizari
New Contributor

Conditional Sum Last 7 Days

I'm trying to make the sum of the last 7 days.

I created the variable vUltimos_7dias.

=(Today()-7)


But when I make the sum as follows, it does not spin, I have already tried in several ways:

Sum({<Data = {>={$(vUltimos_7dias)}>}Visitors)


Thanks.

1 Solution

Accepted Solutions
MVP
MVP

Re: Conditional Sum Last 7 Days

Try this:

Sum( { < Data = { ">=$(vUltimos_7dias)" } > } Visitors )


You might also need to change the vUltimos_7dias to this:


=Date(Today()-7)



2 Replies
jcarlosmh
New Contributor

Re: Conditional Sum Last 7 Days

is Data in numeric format or date format? Today()-7 represents as number not as date

MVP
MVP

Re: Conditional Sum Last 7 Days

Try this:

Sum( { < Data = { ">=$(vUltimos_7dias)" } > } Visitors )


You might also need to change the vUltimos_7dias to this:


=Date(Today()-7)



Community Browser