topic Using a < (Less than) in Set analysis) in QlikView

Using a < (Less than) in Set analysis)

Wed, 02 May 2012 15:04:10 GMT

Hello All,

I'm trying to include a < (Less Than) sign to denote that I want all possible selections which fall before a selected date. However the formula does not seem to return any values. Has anyone ever done this succesfully? Any ideas what such a structure might fail?

The logic I'm trying to get to is:

If (purchase date <= selected date)

And

If (send date month = selected month)

Then

Sum(Revenue)

I hope this is clear. I could really use the help.

Re: Using a < (Less than) in Set analysis)

SunilChauhan — Wed, 02 May 2012 15:06:47 GMT

try this

sum({<[purchase date] = {"<$(Only([purchase date]))"}>} valuefield)

hope this helps

Using a < (Less than) in Set analysis)

Wed, 02 May 2012 15:23:34 GMT

Thanks for your answer but that does not help me. "Only" function returns a value only if a have one and only one selected value. In my case I think Max or MaxString will be a better option.

I tried this but It returns a null.

Sum({$<, Purchase_Date = {"<= $(=Max(SendDate)) "}>} Amount)

Using a < (Less than) in Set analysis)

Wed, 02 May 2012 15:45:31 GMT

I don't think you need that first "," try remoiving it.

Stephen

Re: Using a < (Less than) in Set analysis)

Wed, 02 May 2012 15:51:59 GMT

Yes, you do need the quotes when using expressions like >= <= and similar.

Using a < (Less than) in Set analysis)

Wed, 02 May 2012 15:54:09 GMT

Just to clarify I'm talking about remove the first comma. Igor is right that you need the quotes.

Using a < (Less than) in Set analysis)

Wed, 02 May 2012 16:41:11 GMT

I have tried your suuggestions without getting different results. Thanks for your help so far.

Using a < (Less than) in Set analysis)

cesaraccardi — Wed, 02 May 2012 16:54:29 GMT

Hi, I think you have different date formats... have you checked that?

Using a < (Less than) in Set analysis)

Wed, 02 May 2012 17:43:50 GMT

Thanks for the suggestion but they are formatted correctly. Both in terms of data format and date format.