topic Set Analysis Question in QlikView

Set Analysis Question

Wed, 04 Apr 2012 16:19:12 GMT

Hello Again,

I am having some difficulty with this set analysis. It seems to work when I choose other date dimensions like Fiscal Year, YTD, Quarter to date but when I just try and use Date it is not working.

So, why does this expression work:

=sum({<Date={'4/4/2012'}>}[In company code currency_HSL]*-1*RatetoUSD)

And the one I need to work below does not:

=sum({<Date={$(max (Date)) }>}[In company code currency_HSL]*-1*RatetoUSD)

Thanks again

Re: Set Analysis Question

v_iyyappan — Wed, 04 Apr 2012 16:46:37 GMT

Hi,

Use the expression like this

= Sum({<Datefield={'$(=vMaxDate)'}>}[In company code currency_HSL]*-1*RatetoUSD)

Where vMaxDate = Max(Datefield)

Regards,

Iyyappan

Set Analysis Question

jonathandienst — Wed, 04 Apr 2012 17:01:34 GMT

Sean

Two possible issues:

$(max(Date)) should read $(=max(Date))
$(=max(Date)) returns a number. Set analysis compares on the text representation of the elements and so perhaps this would be better: $(=Date(max(Date)))

Hope that helps

Jonathan

Set Analysis Question

Wed, 04 Apr 2012 17:39:14 GMT

Thank you. This example worked where the other preply to my question did not. Any thoughts as to why it worked using a variable for max date vs the other examples?

Thank you,