topic Multiple if in QlikView

Multiple if

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I am new to QlikView and have found a lot of useful on these forums! However, I cannot work out how to solve the following problem:

I have two calculations as follows:

sum (if ([Entry Date] > (today()-(17*7)), [Total Hrs], '0'))

- this shows me the total number of hours worked in the last 17 weeks

Sum ( {$<Project_Type= {"Project"} >} [Total Hrs])

- this shows me the total number of hours worked on a project (called project in this case) since time started being recorded.

How do I combine the two so I can show total numbers of hours worked on a project in the last 17 weeks?

Thanks!

Wed, 01 Sep 2010 17:15:56 GMT

Hello,

Use below expression...hope that will work..

sum({$<Project_Type = {"Project"},[Entry Date]={">$(=today()-(17*7))"}>} [Total Hrs])

Miguel_Angel_Baeyens — Wed, 01 Sep 2010 17:16:51 GMT

Hello and welcome to the Forums,

I'd try something like

Sum({< [Entry Date] = {">$(=Date(Today() - (17 * 7)))"}, Project_Type = {"Project"} >} [Total Hrs])

Take care of the date and time formats.

Hope that helps!

Wed, 01 Sep 2010 17:23:32 GMT

This seems to have done the trick! Many thanks!!