Skip to main content

Water Cooler

This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Creator III
Creator III

SET ANALYSIS SUM WITH DATE

Hello ,

I have a dimension called "Supplier Date" on which users can filter.

For example if the selected user selects the date of 12/30/2019, I would like to make the sum of supplier purchases <= 12/30/2019.

The user can choose any date from the supplier date dimension. This is why I would like to carry out a set analysis which calculates the sum of supplier purchases compared to the date that the user will select.

So if the user selects 01/31/2019 it will be necessary to calculate supplier purchases which are <= 12/31/2019

Labels (1)
1 Solution

Accepted Solutions
Taoufiq_Zarra

Hi,

Try this :

=sum({$<[Supplier Date]={"<=$(=Date(max([Supplier Date]),'MM/DD/YYYY'))"}>}[Supplier PURCHASES])
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

5 Replies
Taoufiq_Zarra

Hi,

Try this :

=sum({$<[Supplier Date]={"<=$(=Date(max([Supplier Date]),'MM/DD/YYYY'))"}>}[Supplier PURCHASES])
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
jmialoundama
Creator III
Creator III
Author

Hi Taoufiq

 

Thanks you so much for your answer, it's works like i want 🙂

jmialoundama
Creator III
Creator III
Author

I have an other question, if i want to do set analysis between two , it seem like : 

sum({$<[Supplier Date]={">=$(=Date(min([Supplier Date]))<=$(=Date(max([Supplier Date]))"}>}[Supplier PURCHASES])

Taoufiq_Zarra

yes

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
jmialoundama
Creator III
Creator III
Author

Ok thanks 🙂