Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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?
Can you post a screenshot of the chart?
-Rob
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
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