Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Hoowling
Contributor III
Contributor III

Combined set analysis

Hi community,

 

I have an expression that looks like this: 

=Sum({[P1]*$<$(sIgnoreFieldsWF)>}[FC_HistoricalForecast])

The ignore fields variable is used to ignore selections in certain list boxes.

Now I also want to include in the set analysis that only values at max date should be summarized for FC_HistoricalForecast. (i.e. somthing like this: Sum({<[Date]={'$(=Max([Date])'}>} Value)

How do I combine this into the set analysis? 


//Hoowling

Labels (1)
10 Replies
sunny_talwar

How about this?

Sum({[P1] * $<$(sIgnoreFieldsWF), [FC_StoreDate] ={'$(=vMaxDateFC)'}>} [FC_HistoricalForecast])