Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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