Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

Erreur

sum({<[Stock_Mvt. Date Mvt]={'<=$(=ValueList($vDateRef))'}>}[Stock_Mvt. Quantité])


vDateRef est une variable

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Do you really need ValueList function? Are you trying to manage dimension value? If not then use

sum({<[Stock_Mvt. Date Mvt]={'<=$(vDateRef)'}>}[Stock_Mvt. Quantité])

let me know

Not applicable
Author

the same problem. it does not consider as a variable vDateRef

alexandros17
Partner - Champion III
Partner - Champion III

Maybe it depends on the date format, try with this expression (with the appropriate date format) and verify if it works:

sum({<[Stock_Mvt. Date Mvt]={'<=01/01/2014'}>}[Stock_Mvt. Quantité])

Not applicable
Author

Essayez avec cette orthographe : ça fonctionne

It Works

alexandros17
Partner - Champion III
Partner - Champion III

So Verify that your variable has the same format and ... If you think I've helpd you please mark the answer.

Bye