topic Re: Different value types in QlikView

Different value types

ksimons — Thu, 17 Oct 2019 19:59:58 GMT

I need your help with the following problem:

Data:

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

Is there a way to get this with set analysis?

Arthur_Fong — Fri, 18 Oct 2019 00:40:03 GMT

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 — Fri, 18 Oct 2019 01:26:40 GMT

Best shot i can get:

Please provide more info for a better result.

ksimons — Mon, 21 Oct 2019 07:32:47 GMT

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 — Mon, 21 Oct 2019 07:59:25 GMT

There you go:

Refer to qvw attached for reference.

Thanks and regards,

Arthur Fong

ksimons — Mon, 21 Oct 2019 08:09:55 GMT

This will help me. Thank you