Data Points for Peaks in chart

[ZoeM]

Hi Community.

Not sure if this would be an option available through an expression, but in the attached dashboard is there a way to show symbols for the peaks only? 

Trying to draw attention t the high values in the delivery chart and would be nice to distinguish them and still keep the line chart. 

Thanks.

[rwunderlich · Accepted solution]

Download this example qvw and take a look at the "Line Chart" sheet, examples at the bottom. 

Qlikview Cookbook: Tutorial - Annotating Chart Data Points http://qlikviewcookbook.com/recipes/download-info/tutorial-annotating-chart-data-points/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[ZoeM]

Thats exactly what I am looking for and thanks a lot.

However, when I build out the expression in my chart in the actual dashboard the formatting changes and does not show accurately. In my chart I am counting the number of deliveries per month and so I used the below:

If(Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'}>}Gateways)=

max(TOTAL Aggr(Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'}>}Gateways),YearMonth)),

Dual('High Point',Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'}>}Gateways)),'')

It scrunches teh chart and maybe its also because my chart uses YearMonth?

[rwunderlich]

Can you post a screenshot of the chart?

-Rob

[ZoeM]

I was able to fix the issue :):)

But I only see a data point on one peak, is it possibly to have the data point on all peaks? And not just the highest but all high points

[rwunderlich]

It depends on how you define a peak. But yes, you can modify your annotation expression to have multiple conditions, either with OR or using additional if().

Is a peak in your case when a point is higher than points before and after it?  If so, you'll want to take a look at the Above() and Below() functions to get the adjacent peak values.

-Rob