Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Add a second curve to the chart

Hi all,

I am working on some dashboard while one quick questioncomes to me. To simplify it I attach the simple sample:

I load the table Question to the QVD test2. I want to createa chart so that it could always show two curves: one is based on theconstraints I selected, and the other is the average of all curves, which istherefore a constant.

Could anyone tell me how to add the second curve to the charts? Thanks in advance!

Thomas

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Add a second curve to the chart

Sure,

avg is an aggregation function, so you could add a so called set expression to it (if you don't know what's this, you should start reading in the HELP, or maybe here: http://iqlik.wordpress.com/2010/09/11/the-magic-of-set-analysis-syntax-and-examples/

So, I think we could start with disregarding only the sym field selections, right?

=avg({$<sym= >} vol)

You could read it like: average all vol values in current selection record set, but clear selection in field sym.

So your time selections, or any other selections will still be taken into account.

Hope this helps,

Stefan

3 Replies
MVP
MVP

Add a second curve to the chart

Hope I got your problem correctly, I think you need something like

=avg({1} vol)

i.e. disregarding all selections, only taken the dimension into account for averaging vol.

Is this what you were looking for?

Regards,

Stefan

Not applicable

Add a second curve to the chart

Hey Stefan,

Many thanks for your reply. It is very helpful. In reality my situation is a little more complicated. I want the second curve added disregarding some selections but still keep the other. Is there a way to reach that?

Thanks,

Thomas

MVP
MVP

Add a second curve to the chart

Sure,

avg is an aggregation function, so you could add a so called set expression to it (if you don't know what's this, you should start reading in the HELP, or maybe here: http://iqlik.wordpress.com/2010/09/11/the-magic-of-set-analysis-syntax-and-examples/

So, I think we could start with disregarding only the sym field selections, right?

=avg({$<sym= >} vol)

You could read it like: average all vol values in current selection record set, but clear selection in field sym.

So your time selections, or any other selections will still be taken into account.

Hope this helps,

Stefan