Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

materi
New 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
Highlighted
materi
New Contributor III

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

Does anybody know? 😕

materi
New Contributor III

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

Here is the code I wrote:

508,615 * count(Period)

And it doesn't work. Why?

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

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