Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Target based on filter (selected items)

We have an graph showing our sales from the last 5 years per product. (stacked column graph). Beside this graph we have an filter with all our branches. What we want now is when we select certain branches we want to add an target line to the stacked column graph.

Example: When we select branche: 'Hospitals' an target line of 100 needs to be added. I can't find any documentation about what we want to achieve is this possible?

2 Replies
ogster1974
Partner - Master II
Partner - Master II

Set yourself up a separate branch targets table in your data load either inline or from a data source like excel.

Call it

BranchTargets:

It should contain at least

BranchId or name whatever your key is

BranchTarget to store your target value

In reference lines add

=SUM(BranchTarget)

And it should if your mapped your branchkey correctly set a target line based on the branches you have selected.

Hope this helps

Regards

Andy

Not applicable
Author

You can Add the Target line(Reference Line) in Presentation Tab.

If you don't have the data for Target line you you need to give a target explicitly.