topic set analysis error in QlikView

set analysis error

Tue, 13 Oct 2009 22:45:12 GMT

Hello all,

I need help on indirect set analysis. I am currently using v9

[ code ]sum(<Year={"$(=max(Year))"}>,Customer=p({<Year={"$(=max(Year)-1)">}})Sales)/code ]

it should return this year's sales for customers who had sales last year, but I am having syntax error!

Thanks for help

Ryan

set analysis error

Oleg_Troyansky — Tue, 13 Oct 2009 22:59:22 GMT

As much as I can see, you have the two brackets switched places. Try this:

[ code ]

sum(<Year={"$(=max(Year))"}>,Customer=p({<Year={"$(=max(Year)-1)"}>})Sales)

[/code ]

Oleg

set analysis error

Tue, 13 Oct 2009 23:09:34 GMT

Thanks for advice, but it seems to have issues addition to that.

set analysis error

Oleg_Troyansky — Tue, 13 Oct 2009 23:17:47 GMT

can you provide any specifics? Or, even better, post an example?

set analysis error

Tue, 13 Oct 2009 23:38:00 GMT

I am still having syntax errors.

set analysis error

Wed, 14 Oct 2009 00:44:15 GMT

Here is an example file that I actually got from QDays! I am trying to understand the code before I implement indirect set analysis to my project, but example has sytax error

set analysis error

Oleg_Troyansky — Wed, 14 Oct 2009 02:36:13 GMT

See attached. A couple of brackets were missing. The working formula is:

sum( {<Year={"$(=max(Year))"},Customer=p({<Year={"$(=max(Year)-1)"}>})>} Sales)

cheers!

set analysis error

Thu, 15 Oct 2009 00:52:41 GMT

Thanks!