Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a new Function

Hi,

I would like to create a new function that I can use to display in a statistics box. Basically the function would do this equation:

(Total No. Hours) x (Hourly Rate) = Total Service Pay

I was trying this lines on the script but can't seem to make it work.

Sum([# of Hours]) as TotalHours

Sum([# of Hours])*[Hourly Rate] as TotalServicePay

I guess making a function is better. So I can display it on a statistics box.

forums.PNG

11 Replies
Anonymous
Not applicable
Author

Hi Charles,

This is not right:

  1. You are not calling a table.
  2. Your files are not on the same table.
  3. You ar not doing a group by to accumulate values.

But with my other response you will have the correct result.

Regards!

Anonymous
Not applicable
Author

You're wellcome!