Hello to all,
I am a beginner with QlikView.
I would like to filter a table according to a range of dates and to a range of grams per item sold.
I created the variables:
DataMin
DataMax
VendutoMin
VendutoMax
I wrote this script but I do not have the desired result:
if(DATA_ORDINE>=DataMin and DATA_ORDINE<=DataMax,
if(sum(SPEDITO_GRAMMI)>=VendutoMin and Sum(SPEDITO_GRAMMI)<=VendutoMax,sum(SPEDITO_GRAMMI),) ,sum(SPEDITO_GRAMMI))
Can you help me?
Thank you