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
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Arvind_07
Contributor III
Contributor III

Set Analysis- Sum with Conditions

Hi,

I use the following expression to sum a field called [Sch Remaining Qty] based on recent date from the [Run date] field for [material number] dimension.

sum({<[Run Date]={"$(=Max([Run Date]))"}>}[Sch Remaining Qty])

P.S. [Run Date] field contains last 7 days values

But my question is if I use the Run Date field on the Filter pane - Is it possible to modify the above set expression to give me the sum of values based on the filtered date otherwise it should give me the sum of values based on recent date from the [Run Date] field by default(when no filters are applied on the [Run Date] field)

Could someone help me out please. 

Thank you

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

If your expression above is working for no-selection scenario, it should also work the way you want when you select a  date from the field. Have you tried and checked?

View solution in original post

2 Replies
tresesco
MVP
MVP

If your expression above is working for no-selection scenario, it should also work the way you want when you select a  date from the field. Have you tried and checked?

View solution in original post

Arvind_07
Contributor III
Contributor III
Author

Yea it is..:D Thank you