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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Set analysis

HI All,

Why is this expression not working ?

is there anything that i need to change ?

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

Thanks in Advance

16 Replies
qlikview979
Specialist
Specialist

May be this


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

qlikview979
Specialist
Specialist

sorry misunderstand,

may be

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

smilingjohn
Specialist
Specialist
Author

HI Mahesh

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

qlikview979
Specialist
Specialist

if you want today runs  set expression like below

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

qlikview979
Specialist
Specialist

Instead  of Year  put "Date"

smilingjohn
Specialist
Specialist
Author

Yes it worked

Anonymous
Not applicable

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