topic User defined Pivot Table in App Development

User defined Pivot Table

sanjujeeboy — Sat, 16 Nov 2024 02:28:31 GMT

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%

Re: User defined Pivot Table

cheenu_janakira — Mon, 11 May 2020 19:26:44 GMT

Just posted this (https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Easy-Excel-Style-Tables-row-level-formulae-in-Qlik/ta-p/1700513) 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()).