- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry, I guess i should have mentioned that I also want to add the standard deviation for each day
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the F2 and F1 referenced in your file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
F1 and F2 are the fields in his data. Go to script editor and take a look at the script.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Robby,
Did you got the solution???