Why does bigger than not work in this expression?

[#1]

Guys,

Two questions from a newbe:

1. Im writing an expression which should add up all values of year (Date field)>= 2014. If I do:

Sum({<Date={2014}>} Value) it does give me the total of 2014 but if I try

Sum({<Date>={2013}>} Value) / Sum({<Date=>{2013}>} Value) it's not working. Am I overseeing someting?

2.Suppose I want to fill in a variable named vNum1 then

Sum({<Date={vNum1}>} Value)

Does not seem to do the trick. Is there a special way of writing down variables?

[settu_periasamy · Accepted solution]

It should be like

Date={'>2014'}

With variable 

Sum ({<Date={">=$(vNum1)"}>}Value)

[maxgro]

this is from QlikView help (look for set analysis)

replace with your fields