Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

action date on chart based on max value

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.

Capture1.PNG

Please do the needful

Thanks

Thiru

27 Replies
Not applicable
Author

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)


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

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

Thanks

Thiru

Not applicable
Author

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

Not applicable
Author

‌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

Not applicable
Author

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


talk is cheap, supply exceeds demand
Not applicable
Author

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

Not applicable
Author

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.


talk is cheap, supply exceeds demand