topic Re: Allocated Memory Exceeded error in Pivot table in QlikView

Allocated Memory Exceeded error in Pivot table

sadiaasghar — Sat, 16 Nov 2024 17:58:31 GMT

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.

Re: Allocated Memory Exceeded error in Pivot table

sadiaasghar — Tue, 13 Oct 2020 17:58:57 GMT

@Kushal_Chawda @sunny_talwar Please have a look

Re: Allocated Memory Exceeded error in Pivot table

Chanty4u — Tue, 13 Oct 2020 18:01:39 GMT

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

Re: Allocated Memory Exceeded error in Pivot table

sadiaasghar — Tue, 13 Oct 2020 18:29:10 GMT

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.

Re: Allocated Memory Exceeded error in Pivot table

Kushal_Chawda — Tue, 13 Oct 2020 22:41:33 GMT

@sadiaasghar try below

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

Re: Allocated Memory Exceeded error in Pivot table

sadiaasghar — Wed, 14 Oct 2020 05:44:04 GMT

@Kushal_Chawda this is not working either.

Re: Allocated Memory Exceeded error in Pivot table

Chanty4u — Wed, 14 Oct 2020 07:05:13 GMT

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-table/td-p/928372

Re: Allocated Memory Exceeded error in Pivot table

avinashelite — Wed, 14 Oct 2020 07:17:10 GMT

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 ?

Re: Allocated Memory Exceeded error in Pivot table

sadiaasghar — Wed, 14 Oct 2020 07:51:03 GMT

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.

Re: Allocated Memory Exceeded error in Pivot table

Brett_Bleess — Tue, 27 Oct 2020 16:32:02 GMT

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