Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Set Analysis

Erreur

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


vDateRef est une variable

Tags (1)
5 Replies

Re: Set Analysis

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

Re: Set Analysis

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

Re: Set Analysis

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

Re: Set Analysis

Essayez avec cette orthographe : ça fonctionne

It Works

Re: Set Analysis

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

Bye