topic Re: Create Ratios in pivot table in QlikView

Create Ratios in pivot table

Sat, 20 Dec 2014 04:49:33 GMT

Hello,

I have to develop Ratios report of FI module using qlikview 11.0

Report is ready, but the problem is on changing selection of any year or month or any other field, the time it takes to refresh the data is too long.

I have around 40 ratios in 1 pivot table.

Also each ratio is having different expressions.

for e.g some ratios is having as at expression and some ratios YTD expressions.

some ratios is having only Numerator, some ratios i having N/D and some ratios N/(D/D2)

so for all these different types of calculations, I have written if conditions in expressions as below:

if ratio1 then N,

if ratio2 then N/D,

if ratio3 the N/(D/D2)

and so on with different logics.

so please can anyone help to improve the performance of the report.

ecolomer — Sat, 20 Dec 2014 06:23:30 GMT

can you upload the file qv to analyse?

terezagr — Sat, 20 Dec 2014 10:55:23 GMT

Try to put all your expressions in the load script either like flags or like variables.

eg: Load script

vRatio1 = "if ratio1 then N";

in your pivot table than in the expression editor call the variable =$(vRatio1)