Set Analysis

[arvindjha2050]

Hello all,

This is with regard to set analysis :

count({$<Country = {"sum({$<Week = {">$(=$(vTest))"}>}Sales) > 1000"}>}distinct Country)

The double quotes doesn't  work inside the element set , with single quote output is not correct

[Thiago_Justen_]

What about this?

count({$<Country = {"=sum({$<Week = {'>$(vTest)'}>}Sales) > 1000"}>}distinct Country)

[arvindjha2050]

Hello ,

thanks for the reply but this option is already tried , it returns zero instead of correct output

[tresB · Accepted solution]

Hi Arvind,

Single quotes wouldn't work for search strings. Instead try with back quote sign (grave accent) `, like:

count({$<Country = {"=sum({$<Week = {`>$(vTest)`}>}Sales) > 1000"}>}distinct Country)

[arvindjha2050]

Thanks a lot Tresesco , it works