topic Re: Is This Expression is correct Sum({$<year={'$(=Year)','$(=$(=(Year)-1})'}>}Sales)?? in QlikView

Is This Expression is correct Sum({$}Sales)??

Anonymous — Thu, 01 May 2014 10:32:06 GMT

Hi Guys,

I post an expression regarding sum of sales for Current selection and Previous selection of Year..Is that correct expression??

Re: Is This Expression is correct Sum({$}Sales)??

MK_QSL — Thu, 01 May 2014 10:34:37 GMT

Try as below

SUM({<Year = {'$(=Max(Year))'}>}Sales) For Current Year

SUM({<Year = {'$(=Max(Year)-1)'}>}Sales) For Last Year

Let us know what you want to get as a result?

If you want sales for last two year, use as below

=SUM({<Year = {'>=$(=Max(Year)-1)<=$(=Max(Year)) '}>}Sales)

Re: Is This Expression is correct Sum({$}Sales)??

Thu, 01 May 2014 10:35:09 GMT

you want a sum of this year + last year?

Re: Is This Expression is correct Sum({$}Sales)??

Thu, 01 May 2014 10:37:14 GMT

Hi,

Sum({$<year = {'$(=Year)', '$(=(Year - 1))'}>} Sales)

Re: Is This Expression is correct Sum({$}Sales)??

maxgro — Thu, 01 May 2014 11:05:42 GMT

do you mean max year and previous?

=sum({$<Year={$(=max(Year)),$(=max(Year)-1)}>} Sales)

Re: Is This Expression is correct Sum({$}Sales)??

its_anandrjs — Thu, 01 May 2014 11:12:56 GMT

Hi Rajesh,

Use your SET script like below script

=Sum({$<YourYearField = {'$(=Max(YourYearField))' , '$(=Max(YourYearField)-1)' } >}Sales)

Re: Is This Expression is correct Sum({$}Sales)??

Joseph_Musekura — Thu, 01 May 2014 12:39:41 GMT

Did you try

sum ({$<Year={$(#=Only(Year))}, Year={$(#=Only(Year)-1)}>}Sales)

Thanks!

Re: Is This Expression is correct Sum({$}Sales)??

Anonymous — Fri, 02 May 2014 09:35:43 GMT

Yes I want Current and Last year

Re: Is This Expression is correct Sum({$}Sales)??

MK_QSL — Fri, 02 May 2014 09:36:33 GMT

There are so many answers given.

Isn't there any which is solving your problem?

Re: Is This Expression is correct Sum({$}Sales)??

Anonymous — Fri, 02 May 2014 09:37:20 GMT

No But Here # Represents what??

Re: Is This Expression is correct Sum({$}Sales)??

MK_QSL — Fri, 02 May 2014 09:39:11 GMT

=SUM({<Year = {'>=$(=Max(Year)-1)<=$(=Max(Year)) '}>}Sales)

=sum({$<Year={$(=max(Year)),$(=max(Year)-1)}>} Sales)

is not working?

Re: Is This Expression is correct Sum({$}Sales)??

Joseph_Musekura — Fri, 02 May 2014 10:59:40 GMT

Hi,

You need to use # in dollars expansion when dealing with Numeric varaible (see an extract from QlikView reference manual )

Dollar-Sign Expansion Using a Variable

When using a variable for text replacement in the script or in an expression, the following syntax is used:

$( variablename )

$( variablename) expands to the value in variablename. If variablename does not exist the expansion will

be the empty string.

For numeric variable expansions, the syntax $( variablename ) will generate a number using the regional decimal

separator, i.e. for many countries a decimal comma. Such an expansion should not be used for numbers

inside the script since these must use decimal point. Instead the expansion $(# variablename ) should be

used. (Note the hash sign). It always yields a valid decimal-point representation of the numeric value of variablename,

possibly with exponential notation (for very large/small numbers). If variablename does not exist

or does not contain a numeric value, it will be expanded to 0 instead.