topic Re: Why does bigger than not work in this expression? in QlikView

Why does bigger than not work in this expression?

Thu, 19 Nov 2015 17:47:44 GMT

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 — Thu, 19 Nov 2015 18:10:51 GMT

It should be like

Date={'>2014'}

With variable

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

maxgro — Thu, 19 Nov 2015 18:26:30 GMT

this is from QlikView help (look for set analysis)

replace with your fields