Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Partner
Partner

Fractile in distribution plot color expression

Hi all,

I have a problem with a fractile expression used as color expression. I create a distribution Plot as follow

  • 'cliente' as point
  • 'rete' as y-axis
  • 'SUM($(vMisuraAnalisi))/SUM({<RETE>} TOTAL<CLIENTECOMM> $(vMisuraAnalisi))' as measure

I would color each point based on the fractile and to do this I create the following color expression:

if(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
<= Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.05 )
or
sum( $(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
>= Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.95 )
,'#E41B17',
if((sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
> Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.05 )
and
sum($(vMisuraAnalisi))/sum({<RET,CLIENTECOMME>} Total <CLIENTECOMM> $(vMisuraAnalisi))
<= Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ),0.25 )
) or
(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
< Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.95 )
and
sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
>= Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.75 )
),'#4477aa'
,'#94C7FA'
))

It works fine until I select a 'cliente'. I would like that 'cliente' selection doesn't effects on color. I tried different option but not the correct one. 

Please give me a help please, I'm coming crazy with this!

Thanks

Labels (1)