Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Question regarding a formula


I'm pretty new regarding QV. I have some coding background, but still I'm not ready to code by myself. 

So far I have been working on the current script that I have (done by someonelse in the company), but I want to understand the basics first. 

The code below is the one I'm trying to understand. It aims to calculate price where ValorNetoLC is the Revenue and Peso_Neto is the weight in KG. 

Sum({<Id_Fecha={'<=$(xMaxFechaMesFin)'},TipoFCFact={'Producto Terminado'}>}ValorNetoLC_NETWR)/Sum({<Id_Fecha={'<=$(xMaxFechaMesFin)'},TipoFCFact={'Producto Terminado'}>}PESO_NETO)

The question I have here is what does this expression means <=$(xMaxFechaMesFin) doing ?? "Fecha and Mes are some variables that exist, but the xMax and Fin I can't find them.

Hope you can help me

Thanks in advance

Labels (1)
  • sum

2 Replies
Master II
Master II


This only includes those if which are less then xMaxFechaMesFin

Have a read


Learning never stops.
Specialist III
Specialist III

it is variable xMaxFechaMesFin

check your variables list

and it checking 


means ID_Fecha <= xMaxFechaMesFin