topic Re: Making prediction using above() - but future data disappears when a dimension is selected. in QlikView

Making prediction using above() - but future data disappears when a dimension is selected.

william_ericksson — Sun, 21 May 2017 22:16:19 GMT

Hi everyone,

I've built a simple scenario to demonstrate an issue I am having. I have a table with 3 fields: Year, Value and Dimension:

LOAD * INLINE [

Year, Value, Dimension

2015, 31, Site1

2016, 33, Site1

2017, 34, Site1

2018

]

My Year field continues into the future, past the available data. For this future date (2018), I want to present a predicted value. For example purposes, this is the rangeavg() of current value and above() value.

This works well, as long as no dimensions are selected:

However, when a dimension value is selected, the 2018 row disappears:

Can anyone offer a solution to make the 2018 value remain visible in the Test Table regardless of dimension selected? I should add that in my actual scenario, the chart needs to be responsive to dimension selections (ie. site 1, site 2, site 3 etc) so we can't just ignore all selections.

The QVW is attached.

Thanks in advance,

Will

Re: Making prediction using above() - but future data disappears when a dimension is selected.

sunny_talwar — Sun, 21 May 2017 22:43:05 GMT

Try this may be

RangeAvg(Value, Above(Only({1}Value)))

Re: Making prediction using above() - but future data disappears when a dimension is selected.

william_ericksson — Sun, 21 May 2017 23:06:12 GMT

Hi Sunny,

Thanks for your reply.

I had a similar thought. The issue is that {1} means the 2018 value is fixed to the whole dataset no matter which site is selected. I need the QV to limit by dimension as normal, but to continue to display future dates in my calendar against which there is no data.

Interestingly, the following (selecting the desired dimension, as well as the blank dimension) works:

I've added Site2 to the QVW to demonstrate this.

Thanks,

Will

Re: Making prediction using above() - but future data disappears when a dimension is selected.

william_ericksson — Sun, 21 May 2017 23:43:39 GMT

Hi Sunny

I've solved my own problem.

1) In Chart Properties > Dimensions Settings > select Show All Values

This works in the example given.

Cheers Will.