Date selection in set expression not working

[#1]

Hello all,

Am seeing a strange behavior. I want to display the sum of sales just for the Maximum business date, irrespective of selections.

In the attached file, this expression works as expected and give me the results based on comparison.

=Sum({$<business_date = {">=$(=Min(business_date)-1)<=$(=Max(business_date))"}>} Sales)

However, I modified this same expression as below to make it give me sum for just one day (that is the Max of business_date for all the data), it does not work. Always gives me the complete sum.

=Sum({1<business_date = {"=$(=Max(business_date))"}>} Sales)

am I again messing up the syntax?

I have attached the sample files for reference. Please help.

Thanks

Raghu

[#2 · Accepted solution]

Try this:

=Sum({1<business_date = {'$(=Max(business_date))'}>} Sales)

[#3]

Thanks Rebecca,

It worked fine.

I am kind of getting confused with the syntax QlikView works with. I see that you removed the = sign before $ and it worked. My earlier expression was doing a comparison as well and it worked with >= sign.

However, using the = sign did not work in my case. Could you please give some insight on this behaviour?

Thanks

Raghu

[#4]

Here is a good reference:

http://iqlik.wordpress.com/2010/09/11/the-magic-of-set-analysis-syntax-and-examples/