If statment formulas on scatter graph

Wed, 06 Nov 2013 10:34:22 GMT

Hi all,

I have created a few maps using google maps and scatter graphs with coloured pins using following formula:

If(count ([Asset.Serial #])=0, Red(), if (count ([Asset.Serial #])=1 , Yellow(),if (count ([Asset.Serial #])=2, Black() , if (count ([Asset.Serial #])=3 ,Black(), )))

Which works fine.

Howerver I now want to do the same but for a field value instead of a count and I cant seem to get the below to work:

If (Fieldvalue ([Activity.Type])='Demonstration', Red(),)

Many thanks

Paul

Re: If statment formulas on scatter graph

bbi_mba_76 — Wed, 06 Nov 2013 11:04:23 GMT

Hi,

did you try with

If ( [Activity.Type]='Demonstration', Red())

or using the pick/match function

pick(match( [Activity.Type],'Demonstration'), Red()....

topic Re: If statment formulas on scatter graph in QlikView

If statment formulas on scatter graph

Re: If statment formulas on scatter graph