topic Re: not calculating depending on the dimension in QlikView

not calculating depending on the dimension

ecabanas — Wed, 22 Feb 2017 10:33:58 GMT

Hi,

I have some orders and to calculate the freight cost I'm using this formula:

(if(carrier_id='61',if(sum(CoF)=0,'10,2',sum(CoF)*-1), //FBC

if(carrier_id='52',if(sum(CoF)=0,'9,72',sum(CoF)*-1),

if(carrier_id='88',if(sum(CoF)=0,'9,72',sum(CoF)*-1),

)))) //Celeritas)

But if I change the dimension from SalesId to Calendar_Month, the calculation did not work.

Anyone knows why?

Thank's

Eduard

dsharmaqv — Wed, 22 Feb 2017 11:44:09 GMT

can you post your app

sasikanth — Wed, 22 Feb 2017 11:56:54 GMT

Try this,

if (carrier_id='61' and sum(CoF)=0,'10,2',sum(CoF)*-1, //FBC

if(carrier_id='52' and sum(CoF)=0,'9,72',sum(CoF)*-1,

if(carrier_id='88' and sum(CoF)=0,'9,72',sum(CoF)*-1,

))) //Celeritas)