Problem when used aggr and use filters

Wed, 31 Aug 2016 15:21:35 GMT

Hello,

I have a table with a formula that performs a summation with aggr by customer, user and hierarchy of material.

In the dashboard have several fields that we can filter out part of the 3 courses we have in the aggr the formula.

The problem arises because the data shown in the table are different depending on the filters that select, if I do not select a material might result appears me and if I select it gives me another.

Selected Material:

Period	Material	Result
2016_10	xxxxx	100 E

Unchecked Material:

Period	Material	Result
2016_10	xxxxx	53 E
2016_10	yyyy	102 E
2016_10	zzzzz	10 E

This behavior occurs because the aggregation is not taken into account that field, but the problem is that there are about 30 fields that can filter and cannot put all the fields in the aggr by theme perfomance.

You have anyone in this situation?

PS: we cannot do the operations by script.

Thank you.

Re: Problem when used aggr and use filters

sunny_talwar — Wed, 31 Aug 2016 15:59:58 GMT

I think it would be easier to help if we can have a sample to look at. Its difficult to say what might not be working. Would you be able to share a sample or at least some raw data?

topic Re: Problem when used aggr and use filters in QlikView

Problem when used aggr and use filters

Re: Problem when used aggr and use filters