I have a Straight table in Qlik Sense with 140 calculated columns.
Basically, I have derived a Percentage based on 2 inputs. Was wondering, if there is any solution where I can just create a QVD from the Straight table ? so that I can do further analytics instead of writing logics again as this will be too more complex as the set expressions are approx 100 lines each for the 140 columns.
It's not a good idea to transfer a table-calculation approach 1:1 to a data-base oriented tool, like Qlik. I don't want to say that's not possible but it's not sensible. The aim of Qlik is to reduce all the efforts to build and keep dozend or even hundreds of pre-calculated tables else creating only a few small and long ones and then rather simple sum() and count() are enough to get the needed views.
This means they are designed to aggregate field-values and not cells within a crosstable-structure. On top of the aggregations may come some rounding- and/or range-functions to fetch outliers and unify the results and on them may some pick(match()) applied to score and/or cluster the output.
Like above hinted the magic and real work happens within the dimensionalities of the data-model to be able to apply simple expressions and selections to get all wanted views. The first times the how-to might not so obvious. Recommended is to start the development of a data-model as a star-scheme with a single fact-table and n dimension-tables by unifying all field-names and data-structuresand resolving any crosstable-logic. And then step by step going further to acknowledge the relation-ships within the data.
