Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
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()).