Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 

Counting differences between rows


I have two alarms that display dots in a chart if certain conditions are met.

if (isnull(var_x) and [date]<=today(),11)
if (fabs(var_x-Above(var_x))>2.5 ,11.5)

Counting the total number of alarms works for the first one:
count(DISTINCT if([var_x]>10 or [var_x]<=0, [date]&'-'&[name]))

But it doesn't work for the second one:
count(DISTINCT if (fabs([var_x]-Above([var_x]))>2.5 , [date]&'-'&[name]))

(it returns a "Allocated memory exceeded" error).

Suggestions? Thanks!


Labels (2)
1 Reply
Digital Support
Digital Support

Jorge, you are likely going to have to attach the QVW on this one for someone to be able to try to give you some guidance.  In these cases, folks generally need to see the data model as well as the context of the expression etc...

What I can tell you is the message you are getting indicates the calculation is taking up a lot of resources, which would lead me to believe that it is creating some sort of Cartesian product etc., and again, this is where folks will need to see your data model etc. in order to try to figure out what is going on.  


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.