topic Re: Excluding Period selection is not working in QlikView

Excluding Period selection is not working

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In my dashboard, there is one Yearly View tab. I want the data of Yearly View will not affected by Date and Month selection.

It is working for Date. If I select any date, then value is not changing. But not working for Month.

I have used below expression:

=sum(aggr(sum({<DateTransaction_Key= ,CstFiscalPeriod= >}DISTINCT UnitsPlanned),CstFiscalPeriod))

=sum(aggr(sum({<DateTransaction_Key= ,CstFiscalPeriod = >}DISTINCT SalesPlanned),CstFiscalPeriod))

I am attaching my qvw.

Please check and help.

Re: Excluding Period selection is not working

swuehl — Tue, 14 Mar 2017 17:50:10 GMT

Add the set analysis also to the outer aggregation,

=sum({<DateTransaction_Key= ,CstFiscalPeriod= >}

aggr(

sum({<DateTransaction_Key= ,CstFiscalPeriod= >}DISTINCT UnitsPlanned)

,CstFiscalPeriod)

)

Re: Excluding Period selection is not working

swuehl — Tue, 14 Mar 2017 17:50:32 GMT

Set Analysis in the Aggr function

Re: Excluding Period selection is not working

vishsaggi — Tue, 14 Mar 2017 18:03:26 GMT

What is your Month Field here?

Re: Excluding Period selection is not working

mhmmd_srf — Wed, 15 Mar 2017 03:45:10 GMT

Could you please explain me sir..what is the function of outer aggregation?

Thanks,

Sarif

Re: Excluding Period selection is not working

swuehl — Wed, 15 Mar 2017 09:00:35 GMT

The Aggr() function is creating a virtual table with one or more dimensions and an expression.

You would need an (outer) aggregation function to aggregate the content of this virtual table just like you need an aggregation function in any expression:

Dimensions and Measures

The Only Function