Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
It should be like
Date={'>2014'}
With variable
Sum ({<Date={">=$(vNum1)"}>}Value)
It should be like
Date={'>2014'}
With variable
Sum ({<Date={">=$(vNum1)"}>}Value)
this is from QlikView help (look for set analysis)
replace with your fields