{ Set Analysis } Strange issue with identifier

Anonymous — Wed, 18 Nov 2015 15:11:26 GMT

Hi ,

Qlikview uses by default $ ( current selection) as identifier.

In the App , i don't have the same result if i put $ or nothing.

Do you have an explanation ?

My formula :

= (((sum ( {$<DIM1={$(=vAnnee)} , DIM2= {'Structure constante'}, LIB_FAMILLE = >}CA_apres_remise) - sum({$<DIM1={$(=vAnneePrec)} , DIM2 = {'Structure constante'}, LIB_FAMILLE = >}CA_apres_remise)) ) / sum({$<DIM1={$(=vAnneePrec)} , DIM2 = {'Structure constante'}, DIM3 = >}CA_apres_remise))

Result = - 4 , 60 %

= (((sum ( {<DIM1={$(=vAnnee)} , DIM2= {'Structure constante'}, LIB_FAMILLE = >}CA_apres_remise) - sum({<DIM1={$(=vAnneePrec)} , DIM2 = {'Structure constante'}, LIB_FAMILLE = >}CA_apres_remise)) ) / sum({<DIM1={$(=vAnneePrec)} , DIM2 = {'Structure constante'}, DIM3 = >}CA_apres_remise))

Result = - 3, 23 %

Thanks

Lucas

Re: { Set Analysis } Strange issue with identifier

petter — Wed, 18 Nov 2015 15:56:11 GMT

If you operate with Alternate States it will definitely make a difference.

Re: { Set Analysis } Strange issue with identifier

Wed, 17 Aug 2016 09:28:32 GMT

Hi Petter,

can you explain it in more details

Thanks,

Abdul

topic Re: { Set Analysis } Strange issue with identifier in QlikView

{ Set Analysis } Strange issue with identifier

Re: { Set Analysis } Strange issue with identifier

Re: { Set Analysis } Strange issue with identifier