Expression - performance issue

sibin_jacob — Thu, 28 Mar 2013 19:04:26 GMT

Hi,

I have straight table with 145 expressions. my application size is 55MB and its taking more than 1 GB RAM. Table contains metrics like vol, vol chg,% vol chg, Share, Share chg etc. I have 13 products and each product I am calculating almost 10 expressions. In some of the products, expressions are different from one to another. I can't use Pivot table why because the count of columns are not same for all the products.

Bsed on 'Next/Previous' button click, I am showing metrics in table ( At a time only one product metics). But when I am exporting to exccel I need all (145) the columns. Using conditional expression it's improving the performance but order of the rows in the table changing. If I am using hiding expression(presenation tab)

functinality, order of rows not changing but its taking more RAM.

Please give your suggestions to improve the performance( Reduce the Ram usage)

Thanks,

Sibin Jacob.C

topic Expression - performance issue in QlikView

Expression - performance issue