Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.