Ad Hoc Pivot table

[sanjujeeboy]

hi all,

i want to acheive the following layout in qliksense.

there are two date filters : Period 1 and Period 2 . The user selects the respective periods and the data should be populated as below.  how to achieve this?

	Spend	Revenue
Period 1 - 1/1/2020 - 1/8/2020	100	500
Period 2 - 1/9/2020 - 1/16/2020	150	700
Difference %	50%	40%

[dplr-rn]

use value list and try

https://community.qlik.com/t5/Qlik-Design-Blog/ValueList-For-those-tricky-situations/ba-p/1476275

[sanjujeeboy]

Can anyone share the sample QVF for this request.