topic Aggregation Question in QlikView

Aggregation Question

darrellbutler — Fri, 30 Nov 2012 09:14:31 GMT

Hi I have a straight table that works out the variance from a forecast for a given point in the week.

The formula is (wkly forecast - actual sales) / expected to date

This works fine in the chart across its dimensions, but I want to offer users a listbox where they can select % differences. The formula I've built thus far has two problems.

The values are not distinct

and

when i select say 10% it wil bring back all 10% differences for customers but also their other variance differences. Ideally I just want to see 10% differences.

Many thanks

Re: Aggregation Question

Sat, 01 Dec 2012 18:52:07 GMT

could you send small sample file?

Re: Aggregation Question

whiteline — Sun, 02 Dec 2012 19:11:26 GMT

Hi.

I want to offer users a listbox where they can select % differences

In this case you should have some dimension (or goup of dimensions) in your data model so that you could perform such selection.

For example, the cusomer dimension is not sufficient, because the same customer can have different variances for different dates (I guess that's why you see other variances).

When you able to perform such selection manually, you could just use something like this as a listbox expression:

=aggr([your expression], ...dimensions to perform such selection separated by comma...)