topic Re: Pivot table with custom column dimension in App Development

Pivot table with custom column dimension

ali_hijazi — Thu, 15 May 2025 08:03:04 GMT

Hello
below is a screenshot of a pivot table I developed (not all of it appears in this screenshot)

I got on the left 20 expressions and each cell has its own number formatting, money, or percentage or integer
and as a column dimension I have field defined in an inline table as follows:
load * inline [
rpt_colulmn
1
2
3
4...

];

in the definition of the column dimension in the pivot table I defined the following:
pick(rpt_column,'Unit','Actual','Actual %', 'Budget',....)

now in each expression I do the following
pick(rpt_column,

expression1,
expression2,
...

)

the result is correct but the table takes one minute to display result
is there a faster way to accomplish this?
kindly advise

Re: Pivot table with custom column dimension

Aditya_Chitale — Thu, 29 May 2025 07:07:33 GMT

If you are using multiple match parameters in pick, it is bound to take more time to display the table,

one thing that you can check if you are using nested if conditions in your expression part, try to replace them with set analysis if possible.

Regards,

Aditya

Re: Pivot table with custom column dimension

rafaelencinas — Mon, 02 Jun 2025 01:51:43 GMT

Sometimes, the better code to implement our customizations isn't the better for the charts 😞

In this case, you can try to create variables for each column and line to improve speed.

Bye!

Re: Pivot table with custom column dimension

marcus_sommer — Mon, 02 Jun 2025 08:21:02 GMT

Your approach is a nested if-loop - using pick(match()) is only a different syntax - and Qlik calculates at first all branches and picked then the first TRUE result. That is a rather unusual behaviour but it has big benefits by only a few loops with rather simple matching and the complete opposite by returning n complex calculations.

In other words such approach couldn't be fast. Better would be to transfer as much as possible of the calculations within the dimensionalities.