topic Re: Set analysis not working in Aggr function in QlikView

Set analysis not working in Aggr function

Wed, 01 Aug 2012 08:06:56 GMT

Hi All,

In my application there is a chart for year 2010, 2011, 2012 related to certain dimensions. The chart should not be disturbed when i select last 12month ,6 months, 3 months. (All are seperate list box). Below is the expression that i have used in the chart.

=Count({1<'Last 3 Months','Last 6 Months','Last 12 Months'= >}(if(Year=Year([MinDateVarSession]), (aggr(Timestamp,User_Pin,[Session Start])))))

When i select 3 months , the value is getting changed. I am not sure why this is happening , since in my other expression it is working fine. Is this because of AGGR function.

Below expression works fine for another chart,

=Count({$<[Last 3 Months]=,[Last 6 Months]=,[Last 12 Months]= >}distinct if( Year =Year([MinDateVarSession]) ,[Document_Name]))

Please provide a solution

Regards,

Gerard

Re: Set analysis not working in Aggr function

nstefaniuk — Wed, 01 Aug 2012 08:36:00 GMT

Hello,

you have in your wrong formula:

<'Last 3 Months','Last 6 Months','Last 12 Months'= >

And in your good formula:

<[Last 3 Months]=,[Last 6 Months]=,[Last 12 Months]= >

I have never seen the syntax used in wrong formula, so try with the syntax of the good formula.

Re: Set analysis not working in Aggr function

Wed, 01 Aug 2012 08:53:28 GMT

Hi,

Sorry the formula that i have used in my applicaiton is as below , but still its not working.

=Count({$<[Last 3 Months]=,[Last 6 Months]=,[Last 12 Months]= >}distinct(if(Year=Year([MinDateVarSession]), AggR(Timestamp,User_Pin,[Session Start]))))

Re: Set analysis not working in Aggr function

nstefaniuk — Wed, 01 Aug 2012 08:57:31 GMT

I think you are right but it's not a bug. In the help we can found for Aggr:

By default, the aggregation function will aggregate over the set of possible records defined by the selection. An alternative set of records can be defined by a set expression.

Maybe you can achieve it using TOTAL keyword