Announcements
cancel
Showing results for
Did you mean:
Specialist

## 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)
• ### Qlik Sense

1 Solution

Accepted Solutions

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") 😉
5 Replies

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") 😉
Specialist
Author

Hi Taoufiq

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

Specialist
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])

yes

Regards,
Taoufiq ZARRA

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

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

Ok thanks 🙂