Decile analysis table ignore selection

[canmarroig]

Hi, i've a dashboard where i apply a decile analysis in a table like this one http://www.qlikfix.com/2010/10/08/decile-analysis/

now on selecting a set of dimension i want  my table to ignore selection. Is it possibile? Perhaps only a funcion for the whole object Tks

[#2]

Have you tried applying set analysis over the expression in the chart?

Here is a good tuto:
http://community.qlik.com/docs/DOC-1867

[SunilChauhan]

to ignore selection

we can use field= in set analysis

example

sum({<field1>}amount)

it will ignore selection of field1

hope this helps

[canmarroig]

I've tried to use set analysis in Expression and I don't obtain any insensitive effect i've tried also in Dimension:

=if(Profit <= fractile(TOTAL Profit, 0.1), 10,

if(Profit <= fractile(TOTAL Profit, 0.2), 9,

if(Profit <= fractile(TOTAL Profit, 0.3), 8,

if(Profit <= fractile(TOTAL Profit, 0.4), 7,

if(Profit <= fractile(TOTAL Profit, 0.5), 6,

if(Profit <= fractile(TOTAL Profit, 0.6), 5,

if(Profit <= fractile(TOTAL Profit, 0.7), 4,

if(Profit <= fractile(TOTAL Profit, 0.8), 3,

if(Profit <= fractile(TOTAL Profit, 0.9), 2, 1)))))))))

but i don't know how to use set analysis in a if condition at the last position. Tks

[Anonymous]

Hi canmarroig‌ did you manage to solve this issue?