topic Re: Aggr with all dimensions in QlikView

Aggr with all dimensions

Tue, 25 Oct 2011 08:55:54 GMT

Hi everybody,

I'm trying to show theses tables :

Table 1 :

Names | Sales |

Name1 | 100 |

...

Table 2 :

Names | Sales |

Name1 | 200 |

...

Theses two tables are the same except that the first is depending on selections and the second one is for all values

What I have done is this :

Table 1 :

Aggr(sum(sales), Names)

And for the second :

Aggr(sum({1} sales), Names)

But when I selected a dimensions like Country (link to sales not to vendor) the second table is refresh and I have :

Table 2 :

Names | Sales |

Name1 | 100 |

Anyone can help me please ?

Regards,

Adrian

Tue, 25 Oct 2011 14:12:38 GMT

Any help ?

I just want to use the aggr function with excluding selections ..

Thanks

llauses243 — Wed, 26 Oct 2011 08:16:40 GMT

Hi Adrian,

For is necessary to distinct, then you must to add a new field in script

Adjust solution in image attached and box with green border

Important: To consider as reference your field Names as Vendedor mine, Sales as Ano & GE as new field

Good luck, Luis

Moreover has others considerations to use AGGR with Chart or Text Object