Dynanic Trend Line

Thu, 07 Mar 2013 16:17:11 GMT

Hi All,

I have completed adding all the buttons for territory, region and
area to show different charts respectively.

Scenario is if the Area is selected it needs to show all Area as dimension for the respective 4 weeks timeperiod selected.

Dimesion for linechart is Date and Area for this chart for example. The expression behind it is Num(Sum(TRx), '#,##0').

Territory list box as shown in mock up includes all the of the regions, area’s, territory’s and Sales Team for the user to pick individually.

Sales Team has values like Futura, Integra and ...

What I need to figure out is to show the black dotted line all the time on the charts to show the average TRx for the different Sales Team
selected irrespective of any button selections. Currently Futura Digestive Disease is showing per mock up, if
Integra Blue was selected should only show the Integra Blue Avg for TRx.

Users are allowed to Only select one Sales Team at all times.

Attached please find the image that I need to accomplish.

Any thoughts, idea or solution would be very helpful.

Thanks,

Re: Dynanic Trend Line

kaushalview — Fri, 05 Apr 2013 12:33:10 GMT

Hi,

Regards

Kaushal Mehta

Re: Dynanic Trend Line

Gysbert_Wassenaar — Fri, 05 Apr 2013 13:47:51 GMT

See attached example.

Re: Dynanic Trend Line

Mon, 08 Apr 2013 17:03:15 GMT

Thanks a lot Gysbert, this is what I was looking for!

Appreciate your feedback and time!

Thanks,

topic Re: Dynanic Trend Line in QlikView

Dynanic Trend Line

Re: Dynanic Trend Line

Re: Dynanic Trend Line

Re: Dynanic Trend Line