Set analysis a substitute of the above fonction

[#1]

Hello community,

I am trying to show the sales amount prediction of a previous week depending of a variable in my attache qvw file.

When I am using the Above function, it works, but I want to be able to select only one week on my list box and to show the previous week on the calculated expression.

I try the set analysis sample in the help, but I don't find the right expression :-(.

Does someone have an idea on my issue ?

Thanks,

Sébastien

[johnw]

A set is only built once for the entire chart, not once per row. So you can't use it to get the previous week unless only one week is selected. So even with a good expression, it can't even do what the above() function does, and won't solve your problem.

Attached is one solution.