Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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

UPDATED:

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

View solution in original post

2 Replies
Highlighted
MVP
MVP

UPDATED:

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

View solution in original post

Highlighted
Contributor III
Contributor III

Hi Manish,

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

Brian