Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

Decile analysis table ignore selection

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

4 Replies
Not applicable

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
Champion II
Champion II

to ignore selection

we can use field= in set analysis

example

sum({<field1>}amount)

it will ignore selection of field1

hope this helps

Sunil Chauhan
canmarroig
Partner - Creator
Partner - Creator
Author

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
Not applicable

Hi canmarroig‌ did you manage to solve this issue?