This content has been marked as final. Show 2 replies
New Qlik Sense extension released on Qlik Branch: KFTable
Hi, today I released a first version of my first Qlik Sense extension. I call it the KFTable, until I come up with a more suitable name. My ambition is to leverage one of Qlikview/Qlik Sense most powerful features in a more user friendly way, the Set analysis. I want to separate it from the measure as it's own entity, and make it addative. Just like a filter.
The KFTable in this release just uses basic formatting and apperance. 1 dimension and measures for rows. The columns modify the rows measures with set analysis or column expression.
For example let say we have Dimension: Country, Measures: Sales, Grossprofit, Average order value and Units sold. YTD and YTD last year are set analysises added to those measures and YTD YoY% is just an column expression.
|Country||KPI's||YTD||YTD last year||YoY%|
|Sweden||Sales||110 000||100 000||10%|
|Gross profit||12 500||10 000||25%|
|Average order value||400||500||-20%|
When I created a table like this in Qlikview I needed to create measures or variables for the rows times the columns except for the columns that uses column expressions like YoY% "(Column(1)-Column(2))/Column(2)". 4 X 2 = 8. But with this new approach you only need to create rows plus the columns equals 6. When you wan't lots of columns you get alot of measures to manage and it's a hassle. I also tried to make the creation of set analysis a more user friendly in the property interface.
Check out the example app included in the extension!
This is just the first version and I want to improve this with the help of the community and the developers from Qlik.
No reordering of measures or columns
No table formatting
Almost all logic in paint function.
Custom components for better UX