Qlikview Can I make selections/filter data based on background colour

[Anonymous]

Hi

i have a pivot table where i have changed the background colour in my expressions based on values. is there any way i can then filter the data based on the colour

[jyothish8807]

Try this Nicola,

Since it is your calculated Dimension , it will not work like this.

You will have to aggregate the data....

Try the below as expression:

=if((sum({$<product_group_b = {'PM'}>}qty)/ sum(qty) *100) <10,RED(),

if((sum({$<product_group_b = {'PM'}>}qty)/ sum(qty) *100)  >15,Green(),

RGB(255,128,0)))

Br,

KC

[Anonymous]

that is the same calculation i already have

will try to do a sample report to send across

[Anonymous]

how do i send a sample file i have created which gives an example of the data and calculations