Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
materi
Contributor III
Contributor III

Set expression for dividing a number with a row of data in a dataset

Hi,

I think it's better that I describe the problem I have rather than laying out my attempts to code it. Here goes:

I am creating an app that compares the budgeted hours with the self-reported hours for employees at a company. The user should be able to pick any weeks from a list of weeks in a pivot table and see a KPI of the total amount of budgeted hours for the chosen weeks. Each week should have 1/52 of the value of the total hours for the entire year chosen.

If I don't want to add a new field in my dataset with the 1/52 number connected to the relevant fields, how do I go about writing a Set expression to make Sense calculate the correct number in the KPI box?

3 Replies
materi
Contributor III
Contributor III
Author

Does anybody know? 😕

materi
Contributor III
Contributor III
Author

Here is the code I wrote:

508,615 * count(Period)

And it doesn't work. Why?

sunny_talwar

Would you be able to show a sample where we can see the issue?