Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
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

Try this:

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


You might also need to change the vUltimos_7dias to this:


=Date(Today()-7)



View solution in original post

2 Replies
Contributor
Contributor

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

MVP
MVP

Try this:

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


You might also need to change the vUltimos_7dias to this:


=Date(Today()-7)



View solution in original post