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 Gysbert,

Sorry for wrong attachment,Please find the attached App

Thiru

[Gysbert_Wassenaar]

See attached qvw

[#4 · Accepted solution]

Hi Gysbert,

Thanks you so much.

This is the correct answer and it met all the requirements of my problem

Many Thanks for your help

Regards

Thiru

[#5]

Hi Gysbert,

Is there any help for this thread 226450

Please do the needful

Thiru

[#6]

Hi Gysbert,

I have to modify that for crash date and action date

this is your code

=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)

and i want to modify it for

$(Sales Annual Growth Rate)=0 then

=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)

and else

some other syntax    (coulmn(10)/Sales*100)

Please do the needful

Thiru

[#7]

Hi

Please find the attached for qvw file

Regards

Thiru

[#8]

Hi Gysbert,

Any help for this?

Regards

Thiru

[#9]

Hi Gysbert,

I just changed the sales expression,it is now two conditions

Regards

Thiru