Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Chart not calcluating correclty

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

Dropbox - boo.qvw

3 Replies
Highlighted
Not applicable

Hi Samuel,

Try this formula

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

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

Thanks

AJ

Highlighted

HI

PFA

Hope it helps

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

Rate : Sum(Rate)

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

Thanks & Regards,
Mayil Vahanan R
Highlighted
Creator
Creator

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