topic Re: Set analysis with a formula in QlikView

Set analysis with a formula

Thu, 14 May 2015 20:35:27 GMT

Is there a way to use a formula to the left of the operand in set analysis? Example:

I want:

Count({$<Month={'1/1/2015'}>}ID)

To read something like:

Count({$<MonthName(Month)={'1/1/2015'}>}ID)

I've tried numerous ways and I can't seem to figure it out. I know you can do it to the right of the operand, but don't know if it's possible to the left.

This works, as it's on the right of the operand:

Count({$<Month={"$(=MonthName(vMyDate))"}>}ID)

Thanks in advance

Re: Set analysis with a formula

sunny_talwar — Thu, 14 May 2015 20:43:21 GMT

You can do this:

=Count({$<Month={"=MonthName(Month) = 'Jan-2015'"}>}ID)

Assuming your Month is actually a date on which you can apply MonthName

HTH

Best,

Sunny

Re: Set analysis with a formula

petter — Thu, 14 May 2015 20:45:32 GMT

It is not possible to use any kind of expression on the left hand side of the equal sign because this is Set operations ... It compares the Set on the left hand side with the Set on the right hand side. In this case it is a Set of only one element.

The left hand side must contain an explicit field-reference.

Re: Set analysis with a formula

petter — Thu, 14 May 2015 20:46:50 GMT

Sunindia's suggestion is the way to go to achieve what you are looking for.