Allocated Memory Exceeded error in Pivot table

[sadiaasghar]

 i have 2 dimension one is Comapny and the other is calculated dimension and I am using the below expression for calculated dimension in pivot table

IF(match(Company,'ABC'),[Invoice Date_FKDAT],Date(AppDate,'DD/MM/YYYY'))

but it shows allocated memory exceeded but this is working fine in straight table but as per my requirement I have to use Pivot table because i want my calculated dimension in horizontal orientation. Please help anyone.

[sadiaasghar]

@Kushal_Chawda @sunny_talwar Please have a look

[Chanty4u]

Can you create this calculated dimension in script and use that field in chart ?  Did you tried that ?

[sadiaasghar]

I can't because invoice date and App date are fields of two different tables and when i tried to create relationship it gives me loop error because sales table is already related to some other table using a field.

[Kushal_Chawda]

@sadiaasghar  try below

aggr(IF(match(Company,'ABC'),[Invoice Date_FKDAT],Date(AppDate,'DD/MM/YYYY')),Company,[Invoice Date_FKDAT],AppDate)

[sadiaasghar]

@Kushal_Chawda this is not working either.

[Chanty4u]

here in below thread i have seen solution like... 

create a new pivot table and recreate all your dimension and measures - did you tried this?

https://community.qlik.com/t5/QlikView-App-Development/Allocated-memory-exceeded-error-in-pivot-tabl...

[avinashelite]

How are this 2 tables related ? is their 1:1 match or 1:many 

If it has  1:Many and 2 tables are not linked directly then definitely this issue will occur . In Pivot the Dimension values gets aggr to each dimension  value .

Could you create a sample app and share with us ?

[sadiaasghar]

It worked. Now I have 13 records for invoice dates and 2 for App Date. I
want my data to only display dates where invoice date = App Date in my
calculated DIMENSION.

[Brett_Bleess]

I would venture Set Analysis the most likely way to go regarding the last part:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Sorry I do not have anything better.

Regards,
Brett