topic Re: Set analysis in QlikView

Set analysis

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

Why is this expression not working ?

is there anything that i need to change ?

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

Thanks in Advance

Re: Set analysis

Anil_Babu_Samineni — Fri, 16 Jun 2017 09:27:19 GMT

Yes you have to change it like below

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

Re: Set analysis

swuehl — Fri, 16 Jun 2017 09:28:23 GMT

I think there is one closing ) too much:

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

Re: Set analysis

prma7799 — Fri, 16 Jun 2017 09:29:49 GMT

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

Re: Set analysis

smilingjohn — Fri, 16 Jun 2017 09:30:03 GMT

Hi Anil,

This is not working

Re: Set analysis

Anil_Babu_Samineni — Fri, 16 Jun 2017 09:32:11 GMT

As stefan notice one parenthesis looks like extra

Re: Set analysis

smilingjohn — Fri, 16 Jun 2017 09:34:04 GMT

This is giving me the whole total ,

I want to display for the current year today the sum of runs

Re: Set analysis

smilingjohn — Fri, 16 Jun 2017 09:36:04 GMT

HI stefan ,

THis is what i get the expression higlighted by the red lines ..and is nto giving the desired output

Re: Set analysis

prma7799 — Fri, 16 Jun 2017 09:39:38 GMT

instead of open braces ( put curly braces {

Re: Set analysis

Anil_Babu_Samineni — Fri, 16 Jun 2017 09:40:13 GMT

Try this?

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

=sum({$<year=('$(=Max(year))'}>} runs)

Note - I've seen reply to Stefan. Try above

Re: Set analysis

qlikview979 — Fri, 16 Jun 2017 09:41:30 GMT

May be this

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

Re: Set analysis

qlikview979 — Fri, 16 Jun 2017 09:59:35 GMT

sorry misunderstand,

may be

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

Re: Set analysis

smilingjohn — Fri, 16 Jun 2017 10:00:49 GMT

HI Mahesh

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

Re: Set analysis

qlikview979 — Fri, 16 Jun 2017 10:02:42 GMT

if you want today runs set expression like below

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

Re: Set analysis

qlikview979 — Fri, 16 Jun 2017 10:03:47 GMT

Instead of Year put "Date"

Re: Set analysis

smilingjohn — Fri, 16 Jun 2017 10:08:27 GMT

Yes it worked

Re: Set analysis

Anonymous — Fri, 16 Jun 2017 10:18:17 GMT

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