topic Indirect Set Analysis in QlikView

Indirect Set Analysis

Sat, 10 Oct 2009 03:27:54 GMT

Hello all,

I need some 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 which that I can not find.

Thanks,

Ryan

Indirect Set Analysis

Wed, 17 Feb 2010 10:36:25 GMT

Hi Ryan,

Here is the code, I haven't actually checked the results but the syntax is correct and presents some figures to check.

As a tip I would always try and get syntax correct using a pivot table and create a second expression with a '1' in the expression.

This means that there is some data always in the pivot table. This allows you to hover over with the mouse, the expression you are trying to get right, a popup is then presented showing the evaluated $ expansion parts of your expression which you may have wrong.

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

Hope this is of help,

Neil

Indirect Set Analysis

timmy — Wed, 17 Feb 2010 13:18:47 GMT

what does the P in the formula?

p({<Year={$(=max(Year)-1)}>})>}

Indirect Set Analysis

Wed, 17 Feb 2010 13:30:18 GMT

P is for Possible you can also use E for excluded

Indirect Set Analysis

csalcedoa — Mon, 07 May 2012 16:58:49 GMT

Works for me