topic Help needed in the below expression in QlikView

Help needed in the below expression

Anonymous — Thu, 17 Dec 2015 17:59:47 GMT

=aggr(

If(sum({$<Customer_ID, Cust_Year,Category, Product={'Global','State'},Year={">=$(=max(Year)-1)"}>}Value)

>= v_Quartile1,

'Over ' & num(v_Quartile1/$(v_Measure), '$#,##0.0'),

If(sum({$<Customer_ID, Cust_Year, Category, Product={ 'Global','State'}, Year={">=$(=max(Year)-1)"}>}Value)

< v_Quartile2,

'Under ' & num(v_Quartile2/$(v_Measure), '$#,##0.0'),

)) ,Cust_Year))

In the above expression if i select some values in filters for category and Product, the values are changing. I want these filters to be ignored irrelevant of the selections we make in filters.

John

Re: Help needed in the below expression

sunny_talwar — Thu, 17 Dec 2015 18:02:56 GMT

Give this a shot:

=Only({<Category, Product = {'Global', 'State'}>}

Aggr(

If(Sum({$<Customer_ID, Cust_Year,Category, Product={'Global','State'},Year={">=$(=max(Year)-1)"}>}Value)

>= v_Quartile1,

'Over ' & num(v_Quartile1/$(v_Measure), '$#,##0.0'),

If(Sum({$<Customer_ID, Cust_Year, Category, Product={ 'Global','State'}, Year={">=$(=max(Year)-1)"}>}Value)

< v_Quartile2,

'Under ' & num(v_Quartile2/$(v_Measure), '$#,##0.0'))), Cust_Year))

Re: Help needed in the below expression

maxgro — Thu, 17 Dec 2015 18:05:23 GMT

maybe you have to disregard category and product also in

max(Year)

Re: Help needed in the below expression

Anonymous — Thu, 17 Dec 2015 18:11:36 GMT

Thnx Sunny, Actually I tried with Only({1} Aggr expression) but it didn't worked, may i know how different it would behave.

John

Re: Help needed in the below expression

sunny_talwar — Thu, 17 Dec 2015 18:13:50 GMT

Not much, I guess try maxgro‌'s recommendation

Re: Help needed in the below expression

Anonymous — Thu, 17 Dec 2015 18:19:45 GMT

Sure Maxgro, will try this..

John