topic Re: Trend in QlikView

Trend

Anonymous — Fri, 21 Apr 2017 12:33:06 GMT

Hello

In my visualisation I want to add a trendline but I don't want it to adjust when a filter is selected.

How can I do this?

Re: Trend

vinieme12 — Fri, 21 Apr 2017 12:57:07 GMT

how are you adding the trend line?

add and expression with 1 as identifier to ignore all selections

example

Sum({1}Sales) << this will ignore any selections made in the entire app

if you want to ignore a specific field, then

sum({<field1=,field2=>}Sales) << here selections in field1 and field2 will be ignored

Re: Trend

Anonymous — Fri, 21 Apr 2017 13:01:56 GMT

I just made an extra line graph

Re: Trend

vinieme12 — Fri, 21 Apr 2017 13:05:02 GMT

Did you try as above with your expression?

if it's confusing , post the expression for your line and I'll show you where to edit

Re: Trend

Anonymous — Fri, 21 Apr 2017 13:17:53 GMT

So what I want is to have a trendline from stage 1 (the purple bars) in a seperate line graph

Re: Trend

vinieme12 — Fri, 21 Apr 2017 13:27:02 GMT

You should use a combo chart instead of a bar chart

If you are already using a combo chart,

under MEasures >>

Click on the Measure you want to show as line

>> Select Line (Bar | Line | Marker options will be available)

Re: Trend

Digvijay_Singh — Thu, 04 May 2017 15:51:03 GMT

Use combo chart, select one new measure with same expression as Stage 1 measure and select line option in expression tab. This way you will have line and bar both for stage 1, line will appear as a trend.