topic # in set analysis in QlikView

# in set analysis

Anonymous — Fri, 02 May 2014 14:20:50 GMT

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)

Re: # in set analysis

MK_QSL — Fri, 02 May 2014 14:22:14 GMT

Read the last reply on below

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

Re: # in set analysis

maxgro — Fri, 02 May 2014 14:42:35 GMT

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.

Re: # in set analysis

IAMDV — Fri, 02 May 2014 15:08:59 GMT

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,