topic Re: How do you do an if or match against multiple selected values? in QlikView

How do you do an if or match against multiple selected values?

Anonymous — Mon, 01 Jul 2013 06:23:54 GMT

I have two fields with exactly the same names(Fund1 and Fund2). The user does not make any selections in Fund1, and can selected multiple values in Fund2. I create a scatter plot of all the possible values in Fund1 (my only dimension), and want to highlight the values selected in Fund2 (different colour for the datapoints, and possibly even highlight the names.

How can I check if Fund1 matches any of the values selected in Fund2?

Thanks.

Joao.

Re: How do you do an if or match against multiple selected values?

tresB — Mon, 01 Jul 2013 06:36:51 GMT

I am not sure i fi have got your requirement. May be:

Exression like this ? If (Fund1=Fund2, Fund1)

Thanks.

Re: How do you do an if or match against multiple selected values?

Mon, 01 Jul 2013 06:48:38 GMT

if(len(GetFieldSelections(Fund2))>0 ,
Sum( {< Fund1={'$(=GetFieldSelections(Fund2))'}}>}Value)
)

regards-bika

Re: How do you do an if or match against multiple selected values?

Anonymous — Mon, 01 Jul 2013 06:55:01 GMT

Thanks, but Fund2 has multiple selections. Will that work?

Re: How do you do an if or match against multiple selected values?

Anonymous — Mon, 01 Jul 2013 06:58:13 GMT

I'm not following the logic. If more than 1 selection is made in Fund2, you sum the values?

I want to know everytime Fund1 matches Fund2, so that I can color the datapoints!

Thanks.

Joao.