Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

{ Set Analysis } Strange issue with identifier

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

2 Replies
petter
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

Hi Petter,

can you explain it in more details

Thanks,

Abdul