# in set analysis

[Anonymous]

Hi Community,

I recently investigated the various discussions here in the QV Community, but I've found nothing about the use of the symbol # in set analysis. Even in the QV Guide I found no explanations. So I would like to know more about the use and the properties of this element and the differences between this symbol and the $ symbol.

In particular, why does the following formula works:

sum({<field={"=DOLLAR(POUND=date(DataNum))"}>} field2)

while the following one doesn't work:

sum({<field={"=DOLLAR(=date(DataNum))"}>} field2)

?

[MK_QSL]

Read the last reply on below

Is This Expression is correct Sum({$&lt;year={'$(=Year)','$(=$(=(Year)-1})'}&gt;}Sales)??

[maxgro]

from reference manual

Example:

After execution of the following script:

SET DecimalSep=',';

LET X = 7/2;

$(X ) will expand to 3,5 while $(#X ) will expand to 3.5.

[IAMDV]

Using (Pound) after the dollar sign expansion will keep the absolute number instead of rounding off the number. As mentioned by Massimo, please check the reference guide and it's well document.

Thanks,

DV

www.QlikShare.com