topic Re: Calculating Fees in a chart- in QlikView

Calculating Fees in a chart-

Tue, 12 Jun 2012 18:52:30 GMT

Hi All,

im trying to add multiple fees. I use this expression

RangeSum((Cardfee),(technologyfee),(spacefee),(depositamount),(Extrafee))

but this only works if i select one dimession or field. HELP!@!!!!!!!!

deepakk — Wed, 13 Jun 2012 06:22:24 GMT

hi,

You requirement is not clear, can you attach a sample file.

Did u try the below codes

Sum(Cardfee + technologyfee + spacefee + depositamount+ Extrafee)

Sum(Cardfee)+ Sum(technologyfee) + Sum(spacefee) + Sum(depositamount)+Sum(Extrafee)

Deepak

Wed, 13 Jun 2012 20:43:09 GMT

i try this but it doesn't work.

i have numerous Purchase Order (PO) and some of the Fees are 0 which makes my formula work only if i select one PO or there are no 0. HELP

deepakk — Thu, 14 Jun 2012 07:04:14 GMT

hi,

Can you attach the application or send some sample to data to check.

Deepak

Anonymous — Thu, 14 Jun 2012 07:11:18 GMT

hey hi

u can try isnull function n set fee as 1 if some fees are cuming 0.

vaibhav

Anonymous — Thu, 14 Jun 2012 07:51:27 GMT

hi Jafreisy,

Did ur problem resolved?

Thu, 14 Jun 2012 13:20:48 GMT

i was trying sum at the begining and not the sum of each. Thanks all! 😉