topic Re: Aggr sum and set analysis expression problem in QlikView

Aggr sum and set analysis expression problem

Wed, 26 Feb 2014 16:13:50 GMT

Hi.

I´m having problems with an Aggr expression.

To selected year, it works fine, but when I use the same expression, just switching the set analysis to return resuts to previous year, it doesn´t return values.

Variables are returning the years correctly.

To current year: Aggr(sum({$<Ano={$(vcurrentYear)}>}Aggr(valor, idProdutoReservadoValor,Ano)), [Nome Social]) - This works fine!

To previous Year: Aggr(sum({$<Ano={$(vPreviousYear)}>}Aggr(valor, idProdutoReservadoValor,Ano)), [Nome Social]) - Returns 0.

Any ideas?

Thanks in advance.

Regards,

Bruno Silva.

Re: Aggr sum and set analysis expression problem

MK_QSL — Wed, 26 Feb 2014 16:15:14 GMT

If possible please upload your sample file or apps.

Re: Aggr sum and set analysis expression problem

Clever_Anjos — Wed, 26 Feb 2014 16:30:18 GMT

I think your expression should be:

sum($<Ano={$(vcurrentYear)}>}aggr(sum($<Ano={$(vcurrentYear)}>}valor),idProdutoReservadoValor,Ano))

Re: Aggr sum and set analysis expression problem

Wed, 26 Feb 2014 16:40:42 GMT

Sorry, but due to confidentiality issues, I cannot provide sample data.

Re: Aggr sum and set analysis expression problem

Wed, 26 Feb 2014 16:44:11 GMT

Just tested... It returns full data results, not just the selected year. I think that it´s ignoring set analysis and even the selections made!

Re: Aggr sum and set analysis expression problem

Clever_Anjos — Wed, 26 Feb 2014 16:46:46 GMT

Do you have alternate states into your app?

This expression must respect your selections because of $.

Very weird

Re: Aggr sum and set analysis expression problem

Wed, 26 Feb 2014 16:57:56 GMT

I do have Alternate States in the Document, but these Straight Table and the sheet has no active Alternate State. Furthermore, I created specific variables to test these expressions, because it wasn´t me that developed the app, and I wasn´t aware of the full implications of what was already developed.

If I´m not being clear with my text, ask to explain better, please. English is not my native language.

Thanks,

BS.

Re: Aggr sum and set analysis expression problem

Clever_Anjos — Wed, 26 Feb 2014 17:03:35 GMT

You can scramble your data, will make our life easier Preparing examples for Upload - Reduction and Data Scrambling

Re: Aggr sum and set analysis expression problem

Wed, 26 Feb 2014 17:32:40 GMT

Here it is the reduced Qvw, as suggested by Clever Anjos.

The data that is returning as it is, it´s confirmed to be correct. So, any changes to expressions must return same values.

Thanks,

BS.

PSL_Operacional_1.qvw

Re: Aggr sum and set analysis expression problem

Clever_Anjos — Wed, 26 Feb 2014 20:20:57 GMT

I didn´t understand very well your datamodel.

Check if this expression returns what you need for last year

=sum({$<Ano={$(vAnoAntSeleccionado)}>}Aggr(sum({$<Ano={$(vAnoAntSeleccionado)}>}Aggr(only({$<Ano={$(vAnoAntSeleccionado)}>}valor), idProdutoReservadoValor,Ano)), [Nome Social]))

Re: Aggr sum and set analysis expression problem

Thu, 27 Feb 2014 10:27:20 GMT

Thank you very much, Clever Anjos! It worked just perfect!

I don´t understand the data model either! As I said before, It wasn´t me that developed the qvw. And I really think that the model is a mess, but I was told that the business is very complex... I didn´t had the time to analyze it!

Thanks again for your help!

Best Regards,

Bruno Silva.