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

[vishsaggi]

Can you share some sample data to look into. You can create buttons with those expression to select.

[neelamsaroha157]

As per my limited knowledge, I don't think you can do that..

[MarcoWedel]

You could use your background color expression as list box expression (extended with an Aggr() function to consider your dimensions)

[jyothish8807]

Hi Nicola,

Please check this sample. You might get some idea.

Br,

KC

[Anonymous]

Hi

i have tried this using the expression from my pivot as a calculated dimension in another chart - although it says the expression is ok in the expression editor it says error in calculation when i complete the chart

=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)))

[vishsaggi]

Try this? Remove quotes around the numbers

=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)))

[Anonymous]

get the same error once returned to chart

// Error in calculated dimension

[vishsaggi]

Can you share your sample qvw file to look into please?

[MarcoWedel]

what result would you expect this calculated dimension to deliver?