Skip to main content

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 Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
AIShatiLove
Contributor III
Contributor III

sum for the period

Hi, experts
Need to sum money for period  where [date of sales]  between [date 0f sales]-6 months and [date of sales]+ 7 days 
how i can write this condition in table

Labels (2)
3 Replies
Or
Champion
Champion

This is an impossible situation: [date of sales] can never be [date of sales] minus 6 months - it is by definition [date of sales]..?

AIShatiLove
Contributor III
Contributor III
Author

Ok , how then to set the period ?
Is using filter to set this period  good idea ?

Or
Champion
Champion

You can use a separate field to filter this, yes. I'm not sure why you wouldn't simply ask the user to select the range they want, but if they select a single date and you want the range specific above, you can do this in set analysis. See this thread for example syntax: https://community.qlik.com/t5/QlikView-App-Dev/Date-range-in-set-analysis/m-p/965088