topic Re: Total Hours in QlikView

Total Hours

mparker123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have this formula but it doesn't seem to work. If(HOURS='0' and DEPT='44840',MONTH)

The only problem with this is that I need it to be IF Total HOURS=0. How do I write a formula that looks at Total Hours and returns the MONTH field?

Re: Total Hours

Kushal_Chawda — Fri, 08 Sep 2017 13:44:42 GMT

Where you are writing this formula? Is it calculated dimension?

try below

=sum(aggr(if(sum(HOURS)=0 and and DEPT='44840',Month),DEPT,Month))

Re: Total Hours

prieper — Fri, 08 Sep 2017 13:44:51 GMT

in script or in application?

What do you mean with "Total Hours"? Is this a field or should it be the sum of hours or HOURS?

Re: Total Hours

its_anandrjs — Fri, 08 Sep 2017 13:51:45 GMT

In the loading script you are doing this or what

Try

Load

If(HOURS = 0 and DEPT = '44840', MONTH) as FieldName

From Source;

If(HOURS = 0 and DEPT = 44840, MONTH)

Re: Total Hours

mparker123 — Fri, 08 Sep 2017 13:52:37 GMT

In application.

HOURS is the Field name but I want to total the HOURS. In the data set you can have a zero hours logged in one project and 8 hours logged in the other. The way I have the formula it will still show me the MONTH because there is a zero showing in that DAY, so i want to total the HOURS for the day so this doesn't show up.

Re: Total Hours

mparker123 — Fri, 08 Sep 2017 13:53:11 GMT

I am writing an expression in the application

Re: Total Hours

its_anandrjs — Fri, 08 Sep 2017 14:00:30 GMT

Can you provide expected op with example to explain.

Re: Total Hours

mparker123 — Fri, 08 Sep 2017 14:22:44 GMT

Posted an example

Re: Total Hours

prieper — Mon, 11 Sep 2017 07:15:56 GMT

You have used a "Table Box", in which you cannot calculate.

Change to "Straight Table" and have under Presentation "Suppress Zero" and you should get something like the below.

HTH Peter