Set ANalysis !!

[nikhilgarg]

HEy,

In my excel sheet , i have 3 columns :  Year , Customer , Sales.

I want to show Customer name for last year.

I have used following set analysis but it is giving error. Kindly tell em what to do.

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

Thanks

[MK_QSL]

Create a Straight Table

Dimension

1) Year

2) =IF(Year = (Year(Today())-1),Customer)

Tick Suppress When Value is Null for 2nd Dimension

Expression

SUM(Sales)

[tresesco]

Try like:

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

[nikhilgarg]

Hey,

It is still giving me error.

[anbu1984]

Can you post sample qvw

[tresesco]

Try to post your complete expression.

[perumal_41]

Hi Nikhil,

for getting  customer for last year : only({<Year={'$(=max(Year))-1>}) Customer)

for getting  sales for last year : Sum({<Year={'$(=max(Year))-1>}) Sales)

[nikhilgarg]

Hey,

In my question , i have already uploaded my expression.

Thanks

[tresesco]

Missing quotes; improper parenthesis. Try:

only({<Year={'$(=max(Year)-1)'}>} Customer)

sum({<Year={'$(=max(Year)-1)'}>} Sales)

:Note: Only() would only work if there is single customer for the max year, otherwise, try with concat(),k like:

Concat({<Year={'$(=max(Year)-1)'}>} Customer, ',')

[varunjain]

try this

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