Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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