Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: help me write this expression

Try something like this:

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

2 Replies
Not applicable

Re: help me write this expression

Try something like this:

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

MVP
MVP

Re: help me write this expression

Hi,

Try this

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

Hope this helps you.

Regards,

Jagan.

Community Browser