Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.

Easy Excel Style Tables (row-level formulae) in Qlik

No ratings
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Easy Excel Style Tables (row-level formulae) in Qlik

Last Update:

Dec 28, 2020 3:11:14 PM

Updated By:



6-minute video:

Files from Github.

Building Excel-styled tables with different formulae on each row has always been a pain point in Qlik.

We have all created Excel styled spreadsheet using Valuelist as a dimension and PICK MATCH in the expression in order to achieve the cell level control as it is in Excel.

However, this becomes hard to read and maintain when expressions in cells get extremely complex and also fidgety when you need to add new lines in an existing front-end Qlik table.

So I looked for an external way of maintaining these and am now sharing the framework and files to be able to easily create, maintain and change these Excel-style tables in Qlik.

Please watch the YouTube video for more ample information, explanation and instructions.

Contributor III
Contributor III
Here are a couple of Excel xlsm. Hope these get through to you.
Actually thinking back now I'm not sure that is strictly a pivot table in
the usual sense but it's difficult to tell without access to Qlik.
Hope you can make something of this, any questions no problem.

Partner - Contributor III
Partner - Contributor III

@Seggy224 unfortunately it doesn't appear as if the files came through.  Let me DM you and see if that works

Version history
Last update:
‎2020-12-28 06:11 PM
Updated by: