topic Re: Set analysis Help in QlikView

Set analysis Help

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need to sum all sales for the max year and for each unique transaction number.

I was able to sum for the ma year:

sum({<YearPeriod={$(=Max(YearPeriod))}>} [Sales])

but I need to add an additional condition of distinct transaction number so that it will sum one row per each transaction number.

The reason why I have to do this is because there are multiple rows with the same sales amount for unique transaction numbers.

Can anyone help?

swuehl — Fri, 17 Jun 2016 20:25:54 GMT

Sum({<YearPeriod={$(=Max(YearPeriod))}>}

Aggr(

Only({<YearPeriod={$(=Max(YearPeriod))}>} [Sales])

, TransactionID)

)

Fri, 17 Jun 2016 21:03:12 GMT

Great! What if I wanted to include all the years?

swuehl — Fri, 17 Jun 2016 21:08:44 GMT

Sum(

Aggr(

Only( [Sales])

, TransactionID)

)