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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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)

Ask me about Qlik Sense Expert Class!
lucarizziero
Partner - Contributor III
Partner - Contributor III
Author

Great: it works !

thanks a lot