Daily Trend Graph

[#1]

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?

[#2]

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

[avinashelite · Accepted solution]

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

[#4]

What is the F2 and F1 referenced in your file?

[Anonymous]

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

[SunilChauhan]

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

[aveeeeeee7en]

Nice Avinash R

Regards

Aviral Nag

[avinashelite]

Thanks a lot Nag Aviral

Regards,

@vi

[avinashelite]

Hi Robby,

Did you got the solution???