Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

PROBLEM EXCLUDING VALUES

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!

1 Solution

Accepted Solutions
Not applicable

Re: PROBLEM EXCLUDING VALUES

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

5 Replies

PROBLEM EXCLUDING VALUES

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

Not applicable

PROBLEM EXCLUDING VALUES

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

Not applicable

Re: PROBLEM EXCLUDING VALUES

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

Not applicable

Re: PROBLEM EXCLUDING VALUES

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

Not applicable

Re: PROBLEM EXCLUDING VALUES

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