topic Re: Data Points for Peaks in chart in QlikView

Data Points for Peaks in chart

ZoeM — Sat, 16 Nov 2024 04:14:22 GMT

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.

Re: Data Points for Peaks in chart

rwunderlich — Fri, 08 Mar 2019 02:34:22 GMT

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

Re: Data Points for Peaks in chart

ZoeM — Fri, 08 Mar 2019 14:18:12 GMT

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?

Re: Data Points for Peaks in chart

rwunderlich — Fri, 08 Mar 2019 15:19:24 GMT

Can you post a screenshot of the chart?

-Rob

Re: Data Points for Peaks in chart

ZoeM — Fri, 08 Mar 2019 15:55:03 GMT

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

Re: Data Points for Peaks in chart

rwunderlich — Fri, 08 Mar 2019 17:09:37 GMT

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