Qlik Community

Ask a Question

Documents

Qlik Sense documentation and resources.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

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

cheenu_janakira
Creator II
Creator II

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

6-minute video: https://www.youtube.com/watch?v=FQsTiMB9aX4

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.

https://youtu.be/PIR9tsPAvjo

Attachments
Comments
viniamarciano
Contributor
Contributor

Thank you for this @cheenu_janakira . Really helpful. 

One quick question, how do I add more rows? The excel file has 218 editable rows only..

Thanks in advance,

 

Vinia

 

 

0 Likes
cheenu_janakira
Creator II
Creator II

Hi Vinia,

Just unhide the rows in Excel. There is no limit to the amount of rows you can use. Only if you need more columns, then you need to create them and then add them in the .qvs script.

Cheers,

Cheenu

0 Likes
Seggy224
Contributor III
Contributor III

This is brilliant! Really useful and fills a significant gap in Qlik features. Thanks for this.

0 Likes
Seggy224
Contributor III
Contributor III

I have managed to convert this into pure script so now can create Excel style tables using script only. Also can display output in Pivot table which means you can add further dimensions using standard Qlik features and so slice and dice the cells into sub-cells! It's great!

Version history
Revision #:
3 of 3
Last update:
‎2020-12-28 06:11 PM
Updated by: