Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Daily Trend Graph

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?

1 Solution

Accepted Solutions
avinashelite

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

View solution in original post

8 Replies
Not applicable
Author

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

avinashelite

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

Not applicable
Author

What is the F2 and F1 referenced in your file?

Anonymous
Not applicable
Author

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

SunilChauhan
Champion
Champion

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

Sunil Chauhan
aveeeeeee7en
Specialist III
Specialist III

Nice Avinash R

Regards

Aviral Nag

avinashelite

Thanks a lot Nag Aviral

Regards,

@vi

avinashelite

Hi Robby,

Did you got the solution???