aggr() doesn't give correct data

[qvqfqlik]

I need some help with Aggr() not working in the expression. Can you please help me with this.

In the promoresultstesting tab

Before using aggr() in the expression for Customer count the data seems to be this. Requirement is to aggregate for the same Offer number

After using aggr() below is how it is happening, total should be 19, but its aggregating into single row

I have attached the file to this. Please help me with this.

[swuehl]

Looks like 11.20 SR6, build 11.20 12347 is in use.

Maybe time to at least try a current 11.20 release?

Have you also tried to use a pivot table chart instead of the straight table? Maybe the dimension limits total is havin some issues in your software release.

Besides this, are you really sure you want to show 19? As far as I see, there are only 18 distinct customers involved.

[qvqfqlik]

Iam using 11.20.12347 SR6

Yes Stefan, I need to show it 19.

In my first post pictures, the same offernumber has two records , so after aggregating the total would be 19.

I have three different logics in the expressisons.

The last two logics are the ones for the pictures in my initial post.

[swuehl]

It's up to you and your requirements how you need to show the data.

I am just saying, that if you look at your record set, there are 18 distinct customers, not 19.

If you would use the table with the two detailed table lines, I can see why you want to see 18 +1 as total, but if you already group the records into one detailed line?

Well, as said, this is up to you.

Have you considered using a more recent software version or have you tried my sample with the pivot?

I think we can't really help you more, because the suggested solutions seem to work in recent software versions.

[rubenmarin]

There is also the option of changing the label to 'Offer Count' (or similar) to keep saying the truth.

Justify '19' because of counting the non-existant customer seems forced.