Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trend Overlay Chart

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5050.TB01_5F00_20101104_5F00_184157.xls:550:0]Can this visualization be done in Qlikview?

Red lines are limits changing over time.

The green lines are actual result but they are grouped and can be toggled.

Basically I have multiple demensions and multiple expressions, when I have multiple expressions the second dimension disappears?

Demensions = Time & Taskid Group

Expression = UCL, LCL, Result

1 Reply
johnw
Champion III
Champion III

This is a bad solution, but I'm not thinking of a good way to do it. Create two charts, one of them transparent. One chart will have two expressions, UCL and LCL, and it will NOT have the Taskid Group as a dimension. The other chart WILL have the Taskid Group as a dimension, and will only have the Result expression. You'll need to set a static min and max on each chart to make sure they always line up. Ideally, the static min and max would be calculated as the maximum value in either chart. Something along these lines:

rangemax(max(aggr(UCLExpression,"Result Date")),max(aggr(ResultExpression,"Result Date","Task ID")))
rangemin(min(aggr(LCLExpression,"Result Date")),min(aggr(ResultExpression,"Result Date","Task ID")))