# Qlik Sense App Development

New Contributor

## Calculate points if less than or equal to 3

If ‘Goals Scored’ is less than or equal to 3 I want the expression below to calculate otherwise do nothing

=Sum({\$<NumDate= {\$(=(Max([NumDate])))}>}[Goals Scored])

Here is my expression that the expression editor says OK for but when I click Apply, it does not work

=IF ([Goals Scored]<=3,), Sum({\$<NumDate= {\$(=(Max([NumDate])))}>}[Goals Scored])

Here is my data

 Date Country Goals Scored 7/15/2018 France 4 7/15/2018 Croatia 2 7/14/2018 Belgium 2 7/14/2018 England 0 7/11/2018 England 1 7/11/2018 Croatia 2 7/10/2018 France 1 7/10/2018 Belgium 0 7/7/2018 Sweden 0 7/7/2018 England 2 7/7/2018 Russia 5 7/7/2018 Croatia 6 7/6/2018 Uruguay 0 7/6/2018 France 2 7/6/2018 Brazil 1 7/6/2018 Belgium 2

Using the data above my Table chart should look like this …

 Country Goals Scored Belgium 4 Brazil Croatia 4 England 3 France 3 Russia Sweden Uruguay

Can you assist?

1 Solution

Accepted Solutions
Esteemed Contributor

## Re: Calculate points if less than or equal to 3

Hi,

=IF ([Goals Scored]<=3,), Sum({\$<NumDate= {'\$(=(Max([NumDate])))'}>}[Goals Scored])

a comma to remove and two simple quotes to add