Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
BIDev
Creator
Creator

Forecast Value

Hi - I need help in one of the challenges I am facing.

ex: I have data as below in waterfall chart (If not, bar chart also works)

ID   Period     Value
1P1100
2P2150
3P3200
4P1150
5P2100

 

Here ID 1 has value for P1 but not for p2 and P3 - Here I want ID 1 show 100 for forecast  period  p2 and P3 along with P1

Here ID 2 has value for P2 but not for  P3 - Here I want ID 2 show 150 for forecast  period P3 along with P2

Here ID 3 has value for P3 3 show 200 for  P3.

Here ID 4 has value for P1 but not for  p2 and P3  - Here I want ID 4 show 150 for forecast  period  p2 and P3 along with P1

Here ID 5 has value for P2 but not for  P3 - Here I want ID 2 show 100 for forecast  period P3 along with P2

Is this doable at all ?

 

Thank you  much.

Labels (4)
0 Replies