Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Displaying a reference Line in a chart when name selected

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

UPDATED:

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

View solution in original post

2 Replies
Highlighted
MVP
MVP

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

UPDATED:

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

View solution in original post

Highlighted
Contributor III
Contributor III

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

Hi Manish,

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

Brian