topic Re: Allocated Memory Exceeded - Conditional Statement Issue? in QlikView

Allocated Memory Exceeded - Conditional Statement Issue?

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm trying to get a Pie chart to show the data of incidents that were opened in the last 28 days, and are ranked level 1 and level 2. I have created a variable that measures the last 28 days. Below is my code for my expression, is this the reason I'm getting the error message?

Sum(
{<
[Incident Severity Code]={'1','2'},
[Incident Open Date]={'>=$(v28DaysBack)'}
>}
[Incident Counter])

Incident Counter is the number of all incidents, severity code is what level (so I only want level 1's and 2's) and the open date is when they were logged as open.

Speaking to the service manager the memory utilisation is at 60% so nothing to worry about on that front.

Thanks for the help,

Michael

Re: Allocated Memory Exceeded - Conditional Statement Issue?

vishsaggi — Thu, 18 Aug 2016 15:51:18 GMT

What is your expression in that variable can you post it please ?

May be you can try:

Sum( {< [Incident Severity Code]={'1','2'}, [Incident Open Date] = {"$(= '>=' & Date([Incident Open Date], 'MM/DD/YYYY') -28) & '<=' & Date([Incident Open Date], 'MM/DD/YYYY'))" } >} [Incident Counter])

Re: Allocated Memory Exceeded - Conditional Statement Issue?

Thu, 18 Aug 2016 15:55:40 GMT

Hi Vish,

Below is the variable:

v28DaysBack: Date(Today()-28,'dd-MMM-YYYY')

I'll try what you've suggested anyway and it came up with "No data to display".

Thanks,
Michael

Re: Allocated Memory Exceeded - Conditional Statement Issue?

vishsaggi — Thu, 18 Aug 2016 16:14:51 GMT

Can you change your variable to this and try ?

IS your [Incident Open Date] has the same format as your variable date?

Sum(
{<
[Incident Severity Code]={'1','2'},
[Incident Open Date]={" $(= '>=' & '$(v28DaysBack)' & '<=' Date(Today(), 'dd-MMM-YYYY') )" }
>}
[Incident Counter])

Re: Allocated Memory Exceeded - Conditional Statement Issue?

Colin-Albert — Thu, 18 Aug 2016 16:23:59 GMT

The first thing I would check is the data model.

Do the fields you are using exist in separate tables that are not associated in the data model? If so then a Cartesian join is created in memory hence the out-of-memory error.

See this post for more details Re: Why do unlinked tables consume excessive memory?

Re: Allocated Memory Exceeded - Conditional Statement Issue?

Mon, 22 Aug 2016 08:53:12 GMT

They are in the same table from the same source, so I don't think that would be the issue.

Re: Allocated Memory Exceeded - Conditional Statement Issue?

Mon, 22 Aug 2016 08:53:57 GMT

What did you need me to change my variable to? Or should I just change the expression to what you've listed as above?

Michael

Re: Allocated Memory Exceeded - Conditional Statement Issue?

vishsaggi — Mon, 22 Aug 2016 11:50:47 GMT

Sorry I mean can you try the below expression and see if you getting any values.

I presume the IncidentOpenDate is in the same date format 'dd-MMM-YYYY'.

Sum(
{<
[Incident Severity Code]={'1','2'},
[Incident Open Date]={" $(= '>=' & '$(v28DaysBack)' & '<=' Date(Today(), 'dd-MMM-YYYY') )" }
>}
[Incident Counter])

Re: Allocated Memory Exceeded - Conditional Statement Issue?

jonathandienst — Mon, 22 Aug 2016 11:59:23 GMT

First, define the variable slightly differently - add a leading = sign:

Set v28DaysBack = =Date(Today()-28,'dd-MMM-YYYY');

(not a typo, you could also add the = sign in the variable overview)

Then use the expression:

=Sum(

[Incident Severity Code]={'1','2'},

[Incident Open Date]={">=$(=v28DaysBack)"}

[Incident Counter])