Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe this:

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

- Marcus

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe this:

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

- Marcus

View solution in original post