topic Re: Out of Calculation Memory Error in App Development

Out of Calculation Memory Error

bbergstrom — Sat, 16 Nov 2024 06:52:13 GMT

I have a small straight table in Qlik Sense (~8,000 records) and when I try to include the following variable it throws the memory error:

IF(GetSelectedCount(FromBillingMonthNameAbbr)=0,
Sum({<TransactionDate={">=$(=$(vDateFrom)) <=$(=$(vDateTo))"}, FEFTCount={1}>} Gallons),
Sum({<BillingPeriodVal={">=$(=$(vDateBillingFrom)) <=$(=$(vDateBillingTo))"}, FEFTCount={1}>} Gallons))

This is to limit the number of records shown by a couple of filters. What is strange is that if I just add a Sum(Gallons) measure to the table it works fine but returns 100 times more records. I have tried the above in a variable and also in a master measure.

Re: Out of Calculation Memory Error

dplr-rn — Fri, 11 Jan 2019 20:10:20 GMT

Quick question. Why do you have 2 $ declarations in each variable
try with just this format
$(=vDateFrom)

Re: Out of Calculation Memory Error

bbergstrom — Fri, 11 Jan 2019 21:20:20 GMT

This was how I was told to do it from a consultant and when I remove the extra =$ and change it to the below it breaks:

IF(GetSelectedCount(FromBillingMonthNameAbbr)=0,
Sum({<TransactionDate={">=$(vDateFrom) <=$(vDateTo)"}, FEFTCount={1}>} Gallons),
Sum({<BillingPeriodVal={">=$(vDateBillingFrom) <=$(vDateBillingTo)"}, FEFTCount={1}>} Gallons))

Also, when I use this in a KPI object it works fine.

Re: Out of Calculation Memory Error

michelle835 — Sat, 12 Jan 2019 05:29:18 GMT

Can you tell a little bit more about the data model. I guess there are many overlapping fields (fields with same name in both tables) leading into a big synthetic key. Tables should be linked by one field only. So you need to create a composite key to link the tables.

Re: Out of Calculation Memory Error

bbergstrom — Mon, 14 Jan 2019 14:05:52 GMT

Actually there are no synthetic keys.

Re: Out of Calculation Memory Error

bbergstrom — Tue, 15 Jan 2019 14:49:23 GMT

The data model consists of two main QVDs (1 has a record for each fuel transaction and 1 has detail fields for the fuel exceptions) that are joined on a single field called FuelSourceId. This first contains 33.5 millions rows and the second has just under 700K. These are not large QVDs and the app itself is only around 330Mb.

I tried inserting the set analysis directly into the table instead of using a variable and it is working. It's *really* slow but it works.

Just to add a bit more detail I have a dashboard that tracks 5 different fuel exceptions and there are 5 table objects that display the transaction details for each exception type. I am using set analysis here so the table only contains records for that exception type and for the specified date range.

Re: Out of Calculation Memory Error

EnriqueRLancha — Wed, 08 May 2019 10:57:18 GMT

Hi Bbergstom,

It's only an idea, but in my case, when Qlik give thar error was for use a Date Dimension diferent that the formula uses in set analisys.

Regards.

Re: Out of Calculation Memory Error

bbergstrom — Wed, 08 May 2019 13:45:45 GMT

Thanks for the reply! We ended up going a different route with the visuals but I'll keep this in mind.