topic Re: PROBLEM EXCLUDING VALUES in QlikView

PROBLEM EXCLUDING VALUES

Fri, 09 Mar 2012 12:19:05 GMT

Hi there,

I am using the following expressions in a chart:

Label:

MaxString({<GFKBrand={"=rank(total sum({$<GFKBrand-={'BREVILLE','KAMBROOK','SUNBEAM','<TRADEBRAND & EXCLUSIVE>'}>} GFKValue))=2"}>}GFKBrand)

Value Definition:

=sum({<GFKBrand={"=rank(total sum({$<GfKBrand-={'BREVILLE','KAMBROOK','SUNBEAM','<TRADEBRAND & EXCLUSIVE>'}>} GFKValue))=2"}>}GFKValue)
/Sum(Total <YearMnth> GFKValue)

The label seems to work perfectly (2nd ranking value excluding the brands referenced, but the value expression seems to ignore the exclusion in the set analysis.

Any ideas?

Thanks!

PROBLEM EXCLUDING VALUES

CELAMBARASAN — Fri, 09 Mar 2012 12:31:44 GMT

Hi,

I think the value expression should be something like this

=sum({<GFKBrand={"=rank(Aggr(sum({$<GfKBrand-={'BREVILLE','KAMBROOK','SUNBEAM','<TRADEBRAND & EXCLUSIVE>'}>} GFKValue),GFKBrand))=2"}>}GFKValue)
/Sum(Total <YearMnth> GFKValue)

Try it.

Celambarasan

PROBLEM EXCLUDING VALUES

Fri, 09 Mar 2012 13:18:02 GMT

Didn't work unfortunately - it is picking Sunbeam as 2nd brand even though I want it excluded. But it works in Label expression.

Re: PROBLEM EXCLUDING VALUES

Fri, 09 Mar 2012 13:18:42 GMT

Didn't work unfortunately - it is picking Sunbeam as 2nd brand even though I want it excluded. But it works in Label expression.

Re: PROBLEM EXCLUDING VALUES

Fri, 09 Mar 2012 22:40:31 GMT

I found the problme (after a good nights sleep!). I was simpley referencing the field incorrectly ('GfKBrand' - should have been 'GFKBrand'. Doh!

Re: PROBLEM EXCLUDING VALUES

Fri, 09 Mar 2012 22:41:15 GMT

I found the problme (after a good nights sleep!). I was simpley referencing the field incorrectly ('GfKBrand' - should have been 'GFKBrand'. Doh!