topic Re: Set Analysis in QlikView

Set Analysis

Thu, 05 Feb 2015 08:22:36 GMT

Erreur

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

vDateRef est une variable

alexandros17 — Thu, 05 Feb 2015 08:27:11 GMT

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

Thu, 05 Feb 2015 09:22:39 GMT

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

alexandros17 — Thu, 05 Feb 2015 09:29:24 GMT

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é])

Thu, 05 Feb 2015 09:41:40 GMT

Essayez avec cette orthographe : ça fonctionne

It Works

alexandros17 — Thu, 05 Feb 2015 09:48:44 GMT

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

Bye