Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis with two functions

Hi

I have a Set Analysis where I want to only sum the values for the Max forecast submission. I have the expression below that doesnt work .

=sum({<ForecastDate={'$(=date(Max(ForecastDate)))'}>} Volume)

I dont know how to write the expression to get it to sum for only the Maximum forecast Submission which is stored as ForecastDate. I dont mind if I have to use a variable to get it to work. I have tried that as well but cant get the Set Analysis to work there either.

I am happy for any help!

//Fredrik

2 Replies
Gysbert_Wassenaar

You're expression looks correct. If it doesn't work that could be because you misspelled a field name, Qlikview is case-sensitive wrt field names. Or ForecastDate contains strings instead of numeric dates causing max to fail to get the max date. If you need more help post a sample document that demonstrates the issue.


talk is cheap, supply exceeds demand
Not applicable
Author

It was the Date format. The date was displayed 2013-10-07 in list boxes etc but it was stored as 20131007.