AGGR and Set Analysis

[jcampbell474]

I'm trying to get the expression below to work, but it comes to zero.

Sum(Aggr(Sum({< FiscalYearMonth = {"$(=vYMOM)"}>} WP), Product))

I need the sum of WP, aggregated by Product.  The variable is a date reference.  Is there something wrong with my syntax?

Thanks in advance!

[sunny_talwar]

I see where you are coming for, but generally it is kind of difficult to help with out knowing what we are dealing with. May be not for this thread, but do read this -> QlikCommunity Tip: How to get answers to your post?‌

Best,

Sunny

[jcampbell474]

Toni, your advice solved my issue.

I probably should have known about a table box only showing distinct values.  Kept looking everywhere for duplicate records (as did my peers and apparently QV support), but never found any.  Used a straight table w/a count and bam - the dupes appeared.  It just took a simple load distinct to resolve the issue.

I was really scratching my head as it didn't look 'natural' to not see duplicate records but see expressions that indicate duplication exists.

I really appreciate your and Sunny's assistance.  Many, many thanks!