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

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
lucarizziero
Partner - Contributor III
Partner - Contributor III

Expression in which only a list of fields are applied as filters.

I have an expression to which I would apply only a list of fields as filter, ignoring the other selection:

For instance an expression like

SUM({1 <customer_code, order_date, area>} value)

should return the sum of the values limited by the customer_code, order_date and area selected only.

Thanks

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

something like this?


     SUM({1 <customer_code=P(customer_code), order_date=P(order_date), area=P(area)>} value)

lucarizziero
Partner - Contributor III
Partner - Contributor III
Author

Great: it works !

thanks a lot