Transport cost management system

[diegoluppi1993]

Hello to everyone,

we use QlikView in our company and we'll try to setup a transport cost management system with an integration with our Sql Server database .

i'll try to explain the situation: the price list is the Excel file that i've attached; if we consider the vector code and provice as "primary key", the variables are the height of the pallet and te weight.

If we try to setup a program with an "if" function, you think it might work? 

Thanks in advance to all who will reply, if you have better solutions thanks for the suggestions.

Have a nice weekend 🙂 

Diego

[JulesVerne]

I think, your question is not fully understood.. 

What do you mean "if" function.

[diegoluppi1993]

Good morning and thanks for the reply,

i try with this function: if((sum(PesoNetto*[QTA 1 Vendite])-sum(PesoNetto*[QTA 1 Resi Cliente]))>= PesoIniziale and (sum(PesoNetto*[QTA 1 Vendite])-sum(PesoNetto*[QTA 1 Resi Cliente]))
<= PesoFinale, Costo, 'Errore')

If you check the Excel that i've attached, i get only 'Errore', but the expression i think it is ok...