Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
EdgarB
Contributor II
Contributor II

Set analysis : how to do-> sum({<date=previous(date in selection)>}quantity)

Hello, 

I have this set analysis : Sum({$<DAT_START={"$(=Max(DAT_START,2))"}>}[Net Quantity Ordered])

which works if I don't select a DAT_START value in filter pane. 

I Have 3 values in DAT_START : 

1/4/2020

1/10/2020

1/4/2021

 

Do you know how can I change this formula so it can be dynamic ? 

Thanks a lot

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer

Maybe this:

Sum({$<DAT_START={"$(=Max({1} DAT_START,2))"}>}[Net Quantity Ordered])

- Marcus

View solution in original post

1 Reply
marcus_sommer

Maybe this:

Sum({$<DAT_START={"$(=Max({1} DAT_START,2))"}>}[Net Quantity Ordered])

- Marcus