Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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?

Tags (3)
1 Solution

Accepted Solutions

Re: Re: Daily Trend Graph

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

8 Replies
Not applicable

Re: Daily Trend Graph

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

Re: Re: Daily Trend Graph

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

Re: Daily Trend Graph

What is the F2 and F1 referenced in your file?

jsaradhi
Valued Contributor

Re: Daily Trend Graph

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

chauhans85
Esteemed Contributor

Re: Daily Trend Graph

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
Valued Contributor III

Re: Daily Trend Graph

Nice Avinash R

Regards

Aviral Nag

Re: Daily Trend Graph

Thanks a lot Nag Aviral

Regards,

@vi

Re: Daily Trend Graph

Hi Robby,

Did you got the solution???

Community Browser