topic Re: Color Change based on selections in QlikView

Color Change based on selections

Mon, 18 Nov 2013 11:52:02 GMT

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

Re: Color Change based on selections

israrkhan — Mon, 18 Nov 2013 12:00:17 GMT

not connected to qlikview, so could not open the file,

but have you mention the else part..

if(GetFieldSelection(Field)='Underwriter',Blue, if(Underwriter <= 100,Red(),Green()),White())

Re: Color Change based on selections

saumyashah90 — Mon, 18 Nov 2013 12:11:15 GMT

please use this and check

Please check variable definition also

Every time you need not use set analysis

Re: Color Change based on selections

menta — Mon, 18 Nov 2013 12:33:08 GMT

You can try this

if([Underwriter supplying the information]=GetFieldSelections([Underwriter supplying the information]),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()))

)

Re: Color Change based on selections

Tue, 19 Nov 2013 06:09:23 GMT

Hi Carlo,

Thank u so much

This expression works when only one field is selected. What if more than one field is selected.

Please send an expression for it.

Thanks in advance

Soumya

Re: Color Change based on selections

Wed, 20 Nov 2013 06:27:53 GMT

Hi Carlo,

This expression works only when one field is selected.

What if multiple fields are selected.

Could you share the expression for multiple field selections.

Regards,

Keerthi

Re: Color Change based on selections

menta — Wed, 20 Nov 2013 08:55:53 GMT

Ok sorry for delay:

i think this can be a solution

if(substringcount( Concat(GetFieldSelections([Underwriter supplying the information]),' '),[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()))

)

Re: Color Change based on selections

Wed, 20 Nov 2013 09:08:40 GMT

Thanks a lotttttttt Carlo

Re: Color Change based on selections

Wed, 20 Nov 2013 09:16:18 GMT

Hi Carlo,

Its showing in blue(Selected ones) only for first 6 selections later if we select its showing default colors.

What might be the reason for it ?

Regards,

keerhti

Re: Color Change based on selections

menta — Wed, 20 Nov 2013 09:25:23 GMT

6 is the default value for getfieldselections you can change this part into

Concat(GetFieldSelections([Underwriter supplying the information],'',15)

15 is an example you can write your value.

Re: Color Change based on selections

Wed, 20 Nov 2013 09:39:26 GMT

Still we are able to select only 6

Re: Color Change based on selections

menta — Wed, 20 Nov 2013 09:41:21 GMT

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

)

Re: Color Change based on selections

Wed, 20 Nov 2013 09:44:53 GMT

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

)

Re: Color Change based on selections

Wed, 20 Nov 2013 09:49:14 GMT

Yeah Its working fine...

Thanks for your precious time Carlo

Re: Color Change based on selections

Thu, 21 Nov 2013 04:54:37 GMT

Thanks a lot Carlo.

It helped us a lot