Set analysis

[smilingjohn]

HI All,

Why is this expression not working ?

is there anything that i need to change ?

=sum({$<year=("$(=year(Today())))"}>}runs)

Thanks in Advance

[qlikview979]

May be this

=sum({$<YEAR = {"($=Yearstart(Today()))"}>}runs)

[qlikview979]

sorry misunderstand,

may be

=sum(if(Date=Today(),Runs))

[smilingjohn]

HI Mahesh

Its not giving the sumvof current year for today instaead its giving the whole sum of runs

[qlikview979]

if you want today runs  set expression like below

=sum({$<Date={"$(=Today())"}>}Runs)

[qlikview979 · Accepted solution]

Instead  of Year  put "Date"

[smilingjohn]

Yes it worked

[Anonymous]

Hi John,

Use this:

=sum({$<Year={"year(Today())"}>} runs)

Please make sure that the first "year" refers to field name, not to function.

The second year should refer to function.

--------------------------

in your old formula:

=sum({$<year=("$(=year(Today())))"}>}runs)

(" - should be {"

in set analysis: Field={"value"}  

$( ) - used only if you want to get variable's value, here you don't have any variables

=year - you don't need to type "=" second time

)))) - too many