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: 
alexis
Partner - Specialist
Partner - Specialist

Set Analysis question: Only consider impact of certain fields

Hi

At the moment I am getting the SUM of SALES for the ENTIRE dataset {1} subject to the value of a flag and some date ranges as seen below which works as expected..

 

= Sum({1<[SomeFlag] = {'5'}, [EndDateNo] = {'>=$(=Min(DateNo))'}, [StarDateNo] = {'<=$(=Max(DateNo))'} >} Sales)

I have a multi-select box that displays 4 fields (lets call them Field1, ... Field4) - I want to extend the above syntax to consider these selections as well - any suggestions?

Thanks in advance

Alexis

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

4 Replies
Anonymous
Not applicable

Use

Sum({$<[SomeFlag] = {'5'}, [EndDateNo] = {'>=$(=Min(DateNo))'}, [StarDateNo] = {'<=$(=Max(DateNo))'} >} Sales)

$ will itself consider the selections of fields of multibox.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See this document: Ignore all selections except some specific fields using Set Analysis


talk is cheap, supply exceeds demand
alexis
Partner - Specialist
Partner - Specialist
Author

NO

$ will consider ANY selection made - I only want to consider the impact of the 4 fields mentioned 🙂

Thanks for responding

Alexis

alexis
Partner - Specialist
Partner - Specialist
Author

Hi Gysbert

That is EXACTLY what I wanted

THANK YOU!

Alexis