Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
graziellas82
Partner - Contributor II
Partner - Contributor II

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)
0 Replies