Displaying a reference Line in a chart when name selected

Brip51 — Thu, 19 Feb 2015 17:37:26 GMT

Hi,

I am creating a chart that tracks revenue amounts by a particular person,. I want to create a reference line for a quota for each person, but only display the reference line for the person when that person is selected.

I can get as far as selecting ANY of the names with -

=if(substringcount(getcurrentselections(),'FeildMarketName')>0,70000000,0).

I want somthing like -

=if(substringcount(getcurrentselections(),'FeildMarketName') = 'jay',70000000,0) ... That does not work.

I need to get to-

If the value selected for FeildMarketName = A then display the reference line at B value. I know I need some set analysis, but I cant figure out the syntax

Any suggestions or help would be greatly appreciated

Brian

Re: Displaying a reference Line in a chart when name selected

MK_QSL — Thu, 19 Feb 2015 17:49:30 GMT

UPDATED:

=IF(SubStringCount(CONCAT(GetFieldSelections(FeildMarketName) ,'|'),'jay'),70000000,0)

Re: Displaying a reference Line in a chart when name selected

Brip51 — Thu, 19 Feb 2015 18:15:14 GMT

Hi Manish,

Perfect. Thank you. It seems so simple NOW!!!!

Brian

topic Displaying a reference Line in a chart when name selected in QlikView

Displaying a reference Line in a chart when name selected

Re: Displaying a reference Line in a chart when name selected

Re: Displaying a reference Line in a chart when name selected