Qlik Community

Qlik Sense App Development

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

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

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?

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