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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!