topic Re: Date selection in set expression not working in QlikView

Date selection in set expression not working

Wed, 06 Feb 2013 22:26:11 GMT

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

Re: Date selection in set expression not working

Wed, 06 Feb 2013 22:44:05 GMT

Try this:

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

Re: Date selection in set expression not working

Wed, 06 Feb 2013 22:51:58 GMT

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

Re: Date selection in set expression not working

Wed, 06 Feb 2013 23:02:11 GMT

Here is a good reference:

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