topic Re: Needed dimension for correct calculation in QlikView

Needed dimension for correct calculation

jakobjosef — Wed, 22 Aug 2018 06:37:56 GMT

Good morning dear qlik-view-community,

I'm stuck with a problem and do absolutely not know how to solve it. Maybe you can help me, I hope that it is a "typical" problem with an not-to-complicated solution.

My aim is to show the costs of idle-times ("empty hours") of employees. Those get calculated in following way: idle times multiplied with hourly wage:

Every employee has its individual hourly wage, and thats the problem. I want to show the costs of idle times on a monthly basis, without employees. But for correct calculation, I need the dimension "employee", because without this dimension, QV does not know which hourly wage to take.

I would love a result like this:

Does somebody know how to solve this problem? Do I have to use Aggregation-funktion? Or should I hide columns?
I really would appreciate some hints.

Have a nice day & thank you

Jakob

Re: Needed dimension for correct calculation

vishsaggi — Wed, 22 Aug 2018 16:39:58 GMT

use straight table and add Month as your dimension

Dim:

Month

Expr:

= Sum(IdleTimes)

= Sum(IdleTimes * HourlyWage)

Re: Needed dimension for correct calculation

andrey_krylov — Thu, 23 Aug 2018 06:51:09 GMT

Strangely enough, because QV knows which hourly wage to take and result must be as you expect. Could you provide the expression or qvw?

Re: Needed dimension for correct calculation

marcus_sommer — Thu, 23 Aug 2018 07:00:35 GMT

You need an aggr() for it - something like:

sum(aggr(sum([Idle Times] * [hourly wages]), Name, Month))

- Marcus

Re: Needed dimension for correct calculation

jakobjosef — Mon, 27 Aug 2018 06:25:01 GMT

Thank you guys for your answer,

due to technical problems I am not able to try your solutions, but as soon as my problem is fixed I ll try .

Have a nice day,
Jakob

Re: Needed dimension for correct calculation

jakobjosef — Mon, 03 Sep 2018 15:26:35 GMT

Hi guys,

I fixed my problems and prepared a File for you, so maybe you can show me your solution with your QVD-File:

QV-IdleTime.xlsx

There you also find again the description of my problem.

Thank you very much

Jakob

Re: Needed dimension for correct calculation

andrey_krylov — Tue, 04 Sep 2018 06:04:55 GMT

See attached, Jacob

Re: Needed dimension for correct calculation

jakobjosef — Mon, 24 Sep 2018 10:40:11 GMT

Thank you so much, I've finally been able to solve my problem.

Jakob