Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vtatarnikov
New Contributor III

AGGR function changes the value after changing the sorting table

Hi!

AGGR1.png

but

AGGR2.png

Bringing the total number remains the same 22901814.

What is it?

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: AGGR function changes the value after changing the sorting table

Hi,

i'am not sure what is it, but try to add your chart dimension into aggr () dimensions.

And maybe you may share sample allowing us to replicate problem and have a closer look on it.

regards

Darek

4 Replies

Re: AGGR function changes the value after changing the sorting table

The problem is surely related to your data association ...

Not applicable

Re: AGGR function changes the value after changing the sorting table

Hi,

i'am not sure what is it, but try to add your chart dimension into aggr () dimensions.

And maybe you may share sample allowing us to replicate problem and have a closer look on it.

regards

Darek

MVP
MVP

Re: AGGR function changes the value after changing the sorting table

Hi

The previous post is correct. The chart dimensions to the dimensions must be included in the dimensions in the aggr statement.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vtatarnikov
New Contributor III

Re: AGGR function changes the value after changing the sorting table

Yes, that's right.

=sum(Aggr(sum([Количество реализации])*FirstSortedValue([Цена закупки], -[Дата цены]), id_Товара, id_Магазина))

works as it should. thank you very much.

Community Browser