Different value types

[ksimons]

I need your help with the following problem: 

Data:

date	upos	value1	value2
1/1/2019			34
1/1/2019	UP1	157
1/1/2019	UP2	248
1/1/2019	UP3	201
1/1/2019	UP4	151
1/1/2019	UP5	203
1/1/2019	UP6	110
2/1/2019			50
2/1/2019	UP1	178
2/1/2019	UP2	105
2/1/2019	UP3	125
2/1/2019	UP4	123
2/1/2019	UP5	118
2/1/2019	UP6	207
3/1/2019			22
3/1/2019	UP1	217
3/1/2019	UP2	115
3/1/2019	UP3	141
3/1/2019	UP4	137
3/1/2019	UP5	114
3/1/2019	UP6	201

This should be the result when i select 2/1/2019

date	value	value2
1/1/2019		34
2/1/2019	178	50
3/1/2019	105	22
4/1/2019	125
5/1/2019	123
6/1/2019	118
7/1/2019	207

Is there a way to get this with set analysis?

[Arthur_Fong]

Can you please explain on the logic in detail?

I couldn't help if there is no specific patterns in your expected result.

[Arthur_Fong]

Best shot i can get:

Please provide more info for a better result.

[ksimons]

The upos contain the mothly values for the future.

If 2/1/2019 is selected, the value for 3/1/2019 is UP2 from 2/1/2019 (105). The value for 4/1/2019 is UP3 from 2/1/2019 (125)

If 3/1/2019 is selected the value for 4/1/2019 is UP2 from 3/1/2019 (115) 

[Arthur_Fong · Accepted solution]

There you go:

Refer to qvw attached for reference.

Thanks and regards,

Arthur Fong

[ksimons]

This will help me. Thank you