topic Re: Daily Trend Graph in QlikView

Daily Trend Graph

Thu, 31 Jul 2014 02:02:43 GMT

I am trying to create a graph like the example below.

The data is averaged by "day of therapy" (e.g., 1, 2, 3...), then the day's average is graphed.

Any tips on how to calculate the average of a value on a particular day of therapy? Do I need to calculate the "day of therapy" in my SQL query, or can Qlik handle it? Then, how would i create a graph like the below?

Re: Daily Trend Graph

Thu, 31 Jul 2014 02:04:03 GMT

Sorry, I guess i should have mentioned that I also want to add the standard deviation for each day

Re: Re: Daily Trend Graph

avinashelite — Thu, 31 Jul 2014 03:21:22 GMT

Hi Robby,

You can achieve this using box plot Graph and you can handle the calculation in Qlikview.

Refer this attachment and change the calculation according to your need.

Regards,

@vi

Re: Daily Trend Graph

Thu, 31 Jul 2014 15:16:35 GMT

What is the F2 and F1 referenced in your file?

Re: Daily Trend Graph

Anonymous — Thu, 31 Jul 2014 15:27:37 GMT

F1 and F2 are the fields in his data. Go to script editor and take a look at the script.

Re: Daily Trend Graph

SunilChauhan — Thu, 31 Jul 2014 15:34:29 GMT

F1 and F2 are the fieldsName in his data, you could replace F1 as Date in script and front end if you want,

F2 as wahtever you want

Re: Daily Trend Graph

aveeeeeee7en — Sun, 03 Aug 2014 13:57:25 GMT

Nice Avinash R

Regards

Aviral Nag

Re: Daily Trend Graph

avinashelite — Sun, 03 Aug 2014 17:15:14 GMT

Thanks a lot Nag Aviral

Regards,

@vi

Re: Daily Trend Graph

avinashelite — Mon, 04 Aug 2014 05:17:34 GMT

Hi Robby,

Did you got the solution???