help with expression

hopkinsc — Thu, 18 Jul 2013 11:24:20 GMT

Hi All,

I need help with an expression if possible please.

I have a list of telephone charges per period. one of the numbers only has a data charge on it which varies each period. i want to hide this line from the chart (Which i have already done) but also want the charge assigned to this number split out over the rest of the numbers.

I have attached an example..

so the number '8789505158' which for period 6 has a value of £4000, i need this split over the rest of the numbers that appear in the same year and period. So in my example there are 7 numbers for period 6, so the £4000 will need to be split over the 7 numbers (571.14 each)

and for period 7 there are 8 numbers, so the £8000 will need to be split over the 8 numbers (1000 each).

does that make sense?

Re: help with expression

hopkinsc — Thu, 18 Jul 2013 11:36:58 GMT

Sorry, i think i have found the answer..

sum(total<Year,Period>{<[Phone number]={'8789505158'}>}[Recurring Charges])/count({<[Phone number]=-{'8789505158'}>}total<Year,Period>[Phone number])

topic Re: help with expression in QlikView

help with expression

Re: help with expression