Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help me write this expression

Could you help me write:

sum of cen_Class_Data where d_DistanceApart_Miles is LESS THAN OR EQUAL TO varMaxDist? I'm really struggling here.

1 Solution

Accepted Solutions
Not applicable
Author

Try something like this:

=Sum ({$< d_DistanceApart_Miles ={"<=$(varMaxDist)"} > } cen_Class)

View solution in original post

2 Replies
Not applicable
Author

Try something like this:

=Sum ({$< d_DistanceApart_Miles ={"<=$(varMaxDist)"} > } cen_Class)

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try this

=Sum({$<d_DistanceApart_Miles={"<=$(=varMaxDist)"}>}cen_Class_Data)

Hope this helps you.

Regards,

Jagan.