Color Change based on selections

[#1]

Hi,

I want the color of the bar graph to be changed based on the selections.

If selected Underwriter(As per my chart) then it has to come in blue. If selected underwriter's value is less than average then it should be red.

If its more than average it should be in green.

I have attached a qvw file.

Everything works fine when its selected but by default its not coming green.

vAverage and vUnderwriter are the variables used.

I am new to qlikview please reply ASAP

Thanks in adavnce

Soumya

[#2]

Still we are able to select only 6

[menta]

no, you need to change the getfieldselection formula: try this

if(substringcount( Concat(GetFieldSelections([Underwriter supplying the information],'',15),' '),[Underwriter supplying the information] ) >0,Blue(),

if((sum({<[Underwriter supplying the information],Limit_TradeSector,[Current Aon Branch]= >}[Amount Approved GBP]))>$(vAverage),Green(),

If((sum({<[Underwriter supplying the information],Limit_TradeSector,[Current Aon Branch]= >}[Amount Approved GBP]))<$(vAverage),red(),Blue()))

)

[#4]

Hi Soumya,

Try this its working

if(substringcount( Concat(GetFieldSelections([Underwriter supplying the information],'',15)),[Underwriter supplying the information] ) >0,Blue(),

if((sum({<[Underwriter supplying the information],Limit_TradeSector,[Current Aon Branch]= >}[Amount Approved GBP]))>$(vAverage),Green(),

If((sum({<[Underwriter supplying the information],Limit_TradeSector,[Current Aon Branch]= >}[Amount Approved GBP]))<$(vAverage),red(),Blue()))

)

[#5]

Yeah Its working fine...

Thanks for your precious time Carlo

[#6]

Thanks a lot Carlo.

It helped us a lot