Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
william_ericksson
Contributor III
Contributor III

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

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:

02-working.PNG

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

02-not working.PNG


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

1 Solution

Accepted Solutions
william_ericksson
Contributor III
Contributor III
Author

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.

View solution in original post

3 Replies
sunny_talwar

Try this may be

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

william_ericksson
Contributor III
Contributor III
Author

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:

02b.PNG

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

Thanks,

Will

william_ericksson
Contributor III
Contributor III
Author

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.