how to filter char linear table

Tue, 21 Jun 2016 11:10:12 GMT

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

topic how to filter char linear table in QlikView

how to filter char linear table