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

[#1]

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]

Hi,

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

[#3]

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

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

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

[jonasheisterkam]

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.