topic Re: Bug: Multi-Dimension on Pivot Table make Allocated Memory Exceed in QlikView

Bug: Multi-Dimension on Pivot Table make Allocated Memory Exceed

Fri, 23 Jan 2015 05:47:17 GMT

Bug: Multi-Dimension on Pivot Table make Allocated Memory Exceed

Hi,

I create Dashboard, on that i made a pivot table which comprise of 2 Dimension and 1 Expression.

After publishing am facing Error: Allocated Memory Exceed, on particular Pivot table..

Later i found some, way to resolve temporary- i made some calculation in dimension, ie, Date Format.

then i removed the calculation, its look fine after publishing

But need the Date format. Any Idea..

I don't want to change my loading Script....

jonasheisterkam — Fri, 23 Jan 2015 06:24:31 GMT

Hi,

can you post the format you need to generate and the format in the datamodel?

Tue, 27 Jan 2015 10:34:41 GMT

Format in Qlikview = date('MMM-YY')

format in database = date('YYYY-MM-DD')

am trying to do with dimensions... not with expressions..

jonasheisterkam — Tue, 27 Jan 2015 10:48:25 GMT

If you want one dimension value by month try in Dimension

=Date(MonthStart(Date),'MMM-YY')

else you have each day as one value with the same shown text.

In the date functions the performance gab between different functions can be big.

In older versions MonthName() was realy bad, but in the newer its ok.