Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Counting differences between rows

Hi

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
Highlighted
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.  

Regards,
Brett

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.