User defined 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%

Add tags

[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%

[cheenu_janakira]

Just posted this (https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Easy-Excel-Style-Tables-row-level-formulae...) for Excel-styled tables. Give it a shot. Otherwise, you will have to build a data island in the back end and use an if-statement in the front-end or PICK(MATCH()).