action date on chart based on max value

[#1]

Hi 
I have a scenario

I need to show a image or bauble on the crash date which my sale are meeting the max value which is giving by end user.

here i want show image or bauble.

then based on action we need give one more image for action taking before crasing

Exapmle:

Crash date=2018

action =2 means we need to give before two years i.e 2016 a image or bubble

below is action is question mark and crash image is sales is reaching max value.

Please do the needful

Thanks

Thiru

[#2]

Hi

Any help for  that action input box for showing before years?

Thiru

[Gysbert_Wassenaar]

Add another Symbol expression:

below(if(fabs(if(Year<=2016,avg(Sales),Sales+(Sales*$(Sales Annual Growth Rate))/100)

-$(Max %)) = min(total aggr(fabs(if(Year<=2016,avg(Sales),Sales+(Sales*$(Sales Annual Growth Rate))/100)

-$(Max %)),Year)),$(Max %),0),ACTION)

[#4]

Hi Gysbert,

I am not able to implement this.Can you please implement the same in Qvw and please share that file.

Thanks

Thiru

[#5]

Hi Gysbert,

Thanks It's working now.

Almost i was struggling from last 4 weeks,your answer helps me a lot

Thank you very much

Thiru

[#6]

‌Hi Gusbert,

i want show the crash date and action date on top of the chart in text objects

your solution is absolutly working in charts

can you please tell me the syntax for getting that crash date and action dates

Many Thanks in Advance

Thiru

[#7]

Hi Gysbert,

Any solution for getting the crash date and action date?

Please let me know.

Thanks

Thiru

[Gysbert_Wassenaar]

=aggr(if(fabs(if(Year<=2016,avg(Sales),Sales+(Sales*$(Sales Annual Growth Rate))/100)

-$(Max %)) = min(total aggr(fabs(if(Year<=2016,avg(Sales),Sales+(Sales*$(Sales Annual Growth Rate))/100)

-$(Max %)),Year)),Year),Year)

=aggr(if(fabs(if(Year<=2016,avg(Sales),Sales+(Sales*$(Sales Annual Growth Rate))/100)

-$(Max %)) = min(total aggr(fabs(if(Year<=2016,avg(Sales),Sales+(Sales*$(Sales Annual Growth Rate))/100)

-$(Max %)),Year)),Year),Year)-ACTION

[#9]

Hi Gysbert,

If i use above code in text box object it is not showing any thing it is blank

Please do the needful

Thiru

[#10]

Hi Gysbert,

Please find the atatched with your code for crash date and action date.

It is not working.

Please modify it and do the needful

Thiru

[Gysbert_Wassenaar]

That's a completely different app. It does not have any of my expressions anywhere. It also does not have a text box.