topic Re: Decile analysis table ignore selection in QlikView

Decile analysis table ignore selection

canmarroig — Wed, 29 May 2013 14:15:14 GMT

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

Wed, 29 May 2013 14:24:05 GMT

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

SunilChauhan — Wed, 29 May 2013 15:30:44 GMT

to ignore selection

we can use field= in set analysis

example

sum({<field1>}amount)

it will ignore selection of field1

hope this helps

canmarroig — Thu, 30 May 2013 11:17:28 GMT

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 — Thu, 05 Nov 2015 17:28:02 GMT

Hi canmarroig‌ did you manage to solve this issue?