topic Ignore selections aggr in QlikView

Ignore selections aggr

sigurdfjeld — Wed, 20 Apr 2016 10:59:22 GMT

I have a spesific KPI that requires an aggr to get the right result:

sum({1< year = {'$(vYear)'}, SomeDimension= {1}>} numberSomething)

sum({1< year = {'$(vYear)'}>} aggr(

if(year = $(vYear),

numberSomething)

,numberSomething,Dimension1,Dimension2,Dimension3))

But this wont ignore all selections the way i want.

Do anyone have any idea how to do this?

Chanty4u — Wed, 20 Apr 2016 12:06:48 GMT

chk dis

sunny_talwar — Wed, 20 Apr 2016 12:33:34 GMT

May be this:

Sum({1< year = {'$(vYear)'}, SomeDimension= {1}>} numberSomething)

Sum({1< year = {'$(vYear)'}>} Aggr(

If(Only({1} year) = $(vYear), numberSomething), numberSomething,Dimension1,Dimension2,Dimension3))

Sum({1< year = {'$(vYear)'}, SomeDimension= {1}>} numberSomething)

Sum({1< year = {'$(vYear)'}>} Aggr(

Only({1} If(year = $(vYear), numberSomething)), numberSomething,Dimension1,Dimension2,Dimension3))

Sum({1< year = {'$(vYear)'}, SomeDimension= {1}>} numberSomething)

Sum({1< year = {'$(vYear)'}>} Aggr(

Only({1} If(Only({1} year) = $(vYear), numberSomething)), numberSomething,Dimension1,Dimension2,Dimension3))