topic Re: Chart Help in QlikView

Chart Help

Anonymous — Thu, 09 Mar 2017 16:18:22 GMT

Hello-

I have two sets of data, joined by a common field (timeOUT) in a chart. The chart is below.

the issue i'm having is that the green line is an average of a field called RunningTotal (so avg(RunningTotal) as the expression), where there is data in the data set from 0 to 100% (so the full axis). The red line, CurrentSales, does not have a full 100% of data. Whenever i chose a type of product, which then shows the data for the CurrentSales of that product, it limits the green line to only show data up to the point of the CurrentSales timeline. Is there a way to ensure that the avg(RunningTotal) aka the green line always goes to 100% Its a predictive line off previous sales, and showing the full trend is the end goal.

Re: Chart Help

sunny_talwar — Thu, 09 Mar 2017 16:24:32 GMT

May be ignore selection in product for your green line?

Re: Chart Help

Anonymous — Thu, 09 Mar 2017 16:26:52 GMT

how would i go about doing that? they are from related tables, with only timeOUT linking the two, but i'm not sure how to ignore that selection.

Re: Chart Help

sunny_talwar — Thu, 09 Mar 2017 16:31:56 GMT

Would you be able to share a sample?

Re: Chart Help

Anonymous — Thu, 09 Mar 2017 16:38:57 GMT

I cannot share a sample at this time. Is there a general procedure that might be able to help me?

Re: Chart Help

sunny_talwar — Thu, 09 Mar 2017 16:41:05 GMT

May be look here to see how set analysis work

Set Analysis: syntaxes, examples

http://www.learnqlickview.com/qlikview-set-analysis-basics/

Re: Chart Help

Anonymous — Thu, 09 Mar 2017 19:54:45 GMT

so would what that look for me? could you do an average set analysis? could you provide a sample of one?

Re: Chart Help

sunny_talwar — Thu, 09 Mar 2017 20:00:26 GMT

To ignore a field? Lets say you want to ignore selection in FieldName52

Sum({<FieldName52>}Measure)

So within {< .... >} put the name of the field which you want to ignore when you select something

Re: Chart Help

Anonymous — Thu, 09 Mar 2017 20:01:18 GMT

and could i replace sum with average?

Re: Chart Help

Anonymous — Thu, 09 Mar 2017 20:03:02 GMT

that worked, thank you!

Re: Chart Help

sunny_talwar — Thu, 09 Mar 2017 20:04:44 GMT

Sure you can