topic Re: action date on chart based on max value in QlikView

action date on chart based on max value

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: action date on chart based on max value

sunny_talwar — Fri, 15 Jul 2016 11:00:00 GMT

Are you looking for an expression or is this more like a visualization thing? I might not be able to help you with the visualization, but might be able to offer advice on the expression. I just need to understand what exactly is needed in terms of numbers and not so much in terms of action and things on the chart. Can you elaborate?

Re: action date on chart based on max value

Gysbert_Wassenaar — Fri, 15 Jul 2016 11:02:30 GMT

See attached example

Re: action date on chart based on max value

Fri, 15 Jul 2016 11:10:56 GMT

Hi Sunny

sales is my values

Max is target which can set by the end user or customer

based on start data and end date the chart will show the years

based on Sales Annual Growth Rate the forecast data will vary (means it will increase i.e Sales+(Sales*$(Sales Annual Growth Rate))/100)

Action is some thing which end user will need to take steps before action years which this also end user will give

Now i want to know on which year the sales line is meeting the max value(because it may not exact value of max

ex: max=100 and slaes is 99 and 103 105 like that,so only i asked about first sorted values)

Note:but first sorted values will work for column not for expression

1.i want that crash year date based on expression

2.and if possible any images or bubbles need to add that area as shown in the picture

If any clarification please let me know

Thanks

Thiru

Re: action date on chart based on max value

sunny_talwar — Sat, 16 Jul 2016 04:05:01 GMT

Have you looked at Gysbert's proposed solution? It seems that his solution meets your requirement. Let us know if it doesn't and we can further explore.

Best,

Sunny

Re: action date on chart based on max value

Mon, 18 Jul 2016 06:59:51 GMT

I am not able to see any attachment?

Thiru

Re: action date on chart based on max value

Mon, 18 Jul 2016 07:03:30 GMT

Hi Sunny,

At least i want to know hoe to get that crash date.

As discussed we are able to find the date using first sorted values if it is column it is working,but it is a expression it is not working

Thiru

Re: action date on chart based on max value

sunny_talwar — Mon, 18 Jul 2016 08:43:49 GMT

Open this link to see a qvw attached to Gysbert's response:

Re: action date on chart based on max value

Mon, 18 Jul 2016 10:24:52 GMT

Hi Gysbert,

Thanks for your solution.It's working.For continuous that there is a variable called action which is input box in the qvw application.

This is same waht we are giving cross mark for end user which is already you shown for crash date.

for example if i select 1 before one year crash date it need to show the cross mark i.e

one is for crash date (which is already done)

one is for before action months( i am looking)

Please do the needful

Thanks

Thiru

Re: action date on chart based on max value

Mon, 18 Jul 2016 10:37:56 GMT

Hi Sunny,

I got he solution as per Gysbert Logic.It filled half of my requirement in the image which i uploaded is showing two images

1. crashdate(which is Gysbert Logic)

2.Question mark symbol which will before action years based on action input in the application.

Now how to know the date of crash of actual vs target?

Thanks

Thiru

Re: action date on chart based on max value

Mon, 18 Jul 2016 13:32:15 GMT

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

Thiru

Re: action date on chart based on max value

Gysbert_Wassenaar — Mon, 18 Jul 2016 15:57:38 GMT

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)

Re: action date on chart based on max value

Tue, 19 Jul 2016 06:10:28 GMT

Hi Gysbert,

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

Thanks

Thiru

Re: action date on chart based on max value

Tue, 19 Jul 2016 06:21:50 GMT

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

Re: action date on chart based on max value

Tue, 19 Jul 2016 15:51:30 GMT

‌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

Re: action date on chart based on max value

Wed, 20 Jul 2016 06:41:50 GMT

Hi Gysbert,

Any solution for getting the crash date and action date?

Please let me know.

Thanks

Thiru

Re: action date on chart based on max value

Gysbert_Wassenaar — Wed, 20 Jul 2016 06:52:32 GMT

=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

Re: action date on chart based on max value

Wed, 20 Jul 2016 07:44:00 GMT

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

Re: action date on chart based on max value

Wed, 20 Jul 2016 07:47:14 GMT

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

Re: action date on chart based on max value

Gysbert_Wassenaar — Wed, 20 Jul 2016 08:04:41 GMT

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