topic Re: Chart not calcluating correclty in QlikView

Chart not calcluating correclty

samuel_brierley — Wed, 15 Jan 2014 16:08:46 GMT

I have a Chart that I have used many times and just change the dimensions but for some reason when I change the dimension to contract it gives in.

the chart should multiply the hours worked on a contract by the Rate.

I have previewed the data and I can clearly see for example a contract with hours booked to it and a rate assigned but the chart just wont do it.

The drop box link is a very small except of what Im doing and more importantly what isnt working.

Im only a desktop user so unfortunatly I am unable to open other qvw. thanks for the help

Wed, 15 Jan 2014 19:18:34 GMT

Hi Samuel,

Try this formula

=sum({$<Contract={"*"}>} [Total Hours] * Rate )

Hope it helps. Let me know if you have any questions

Thanks

MayilVahanan — Wed, 15 Jan 2014 19:59:01 GMT

PFA

Hope it helps

Total hours: =sum({$<Contract={"*"}>} [Total Hours])

Rate : Sum(Rate)

Total Hours * Rate : =sum({$<Contract={"*"}>} [Total Hours])* Sum(Rate)

samuel_brierley — Thu, 16 Jan 2014 09:29:33 GMT

thank you this is sorted, such a small buuger of an error