Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How are these two Set Expressions different?

I would like to know why these two expressions would return different results?

They both fundamentally seem the same to me

=num(Sum({$<d_DistanceApart_Miles={">=0<=$(=varMaxDist)"}>}cen_Class_Data),'###,##0')

=num(Sum({$<cen_Class_Data=P({1<d_DistanceApart_Miles={"<=$(=varMaxDist)"}>}cen_Class_Data)>}cen_Class_Data),'###,##0')

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

First expression returns the sum of cen_Class_Data which has d_DistanceApart_Miles greater than 0 and less than varMaxDist value.

Second expression returns the sum cen_Class_Data which has d_DistanceApart_Miles less than varMaxDist value.

Hope this helps you.

Regards,

Jagan.

View solution in original post

3 Replies
Not applicable
Author

they seem to be formatted horribly.

Maybe this is more clear

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

=num(Sum({$<cen_Class_Data=P({1<d_DistanceApart_Miles={"<=$(=varMaxDist)"}>}cen_Class_Data)>}cen_Class_Data),'###,##0')

jagan
Luminary Alumni
Luminary Alumni

Hi,

First expression returns the sum of cen_Class_Data which has d_DistanceApart_Miles greater than 0 and less than varMaxDist value.

Second expression returns the sum cen_Class_Data which has d_DistanceApart_Miles less than varMaxDist value.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

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.