topic Re: Transport cost management system in QlikView

Transport cost management system

diegoluppi1993 — Sat, 26 Mar 2022 14:58:07 GMT

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

Re: Transport cost management system

JulesVerne — Sun, 27 Mar 2022 19:33:51 GMT

I think, your question is not fully understood..

What do you mean "if" function.

Re: Transport cost management system

diegoluppi1993 — Mon, 28 Mar 2022 07:48:55 GMT

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...