why is not ok for same expression.

[#1]

the express is ok :

:   COUNT({<SHOPKEY= {"=(sum(SALES>0)"}  DISTINCT SHOPKEY)     is ok .

the same :

    COUNT({<SHOPKEY= {"=(sum(year={"$(=max(year)-1)"}SALES>0)"}  DISTINCT SHOPKEY)   isn't ok ,why ?

I want to get the number of shop which  have  sales in the the two year's same monthes .

example:

   sales     201401   201301      count(result)

shop1      234        230           1

shop2      0            230           0

shop3       344         0              0

how to write  it in table?

[PrashantSangle]

Hi,

I am not sure but try this expression

=COUNT({<SHOPKEY= {"=sum(SALES) > 0"},YEAR={'$(=max(YEAR))'}>}DISTINCT  SHOPKEY)

[#3]

get wrong number

[PrashantSangle]

Hi,

Can you post your sample data,

and what is your dimension?

[#5]

like example:

   sales     201401   201301      count(result)

shop1      234        230           1

shop2      0            230           0

shop3       344         0              0

shop4      0             0              0

shop5    -400        234          0

[jonathandienst]

Hi

Is the field "YEAR" or "year". QV field names are case sensitive, so these are not the same field. Set analysis simply ignores invalid field names.

HTH

Jonathan