Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

User defined Pivot Table

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?

 SpendRevenue
Period 1 - 1/1/2020 - 1/8/2020100500
Period 2 - 1/9/2020 - 1/16/2020150700
Difference %50%40%

 

Labels (3)
1 Reply
Highlighted
Creator II
Creator II

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()).