topic Re: Qlikview Can I make selections/filter data based on background colour in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

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

vishsaggi — Thu, 16 Aug 2018 17:52:42 GMT

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

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

neelamsaroha157 — Thu, 16 Aug 2018 18:56:34 GMT

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

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

MarcoWedel — Thu, 16 Aug 2018 21:26:36 GMT

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

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

jyothish8807 — Fri, 17 Aug 2018 05:34:43 GMT

Hi Nicola,

Please check this sample. You might get some idea.

Br,

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

Anonymous — Mon, 20 Aug 2018 09:16:00 GMT

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

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

vishsaggi — Mon, 20 Aug 2018 16:19:01 GMT

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

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

Anonymous — Mon, 20 Aug 2018 16:22:16 GMT

get the same error once returned to chart

// Error in calculated dimension

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

vishsaggi — Mon, 20 Aug 2018 16:30:41 GMT

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

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

MarcoWedel — Mon, 20 Aug 2018 20:14:05 GMT

what result would you expect this calculated dimension to deliver?

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

jyothish8807 — Tue, 21 Aug 2018 05:01:23 GMT

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,

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

Anonymous — Tue, 21 Aug 2018 08:08:52 GMT

that is the same calculation i already have

will try to do a sample report to send across

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

Anonymous — Tue, 21 Aug 2018 09:46:31 GMT

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