topic Re: Add depending on dates in QlikView

Add depending on dates

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

Hello all,

I'm trying to add values depending on whether the dates are the same or not, for example, i have a QVD with a table that contains the following dates:

Name	Start	Finish	Number
Name 1	01/01/2017	01/01/2017	6
Name 1	03/02/2017	11/12/2017	4
Name 1	02/02/2017	02/02/2017	5

When I use this expression If(date(Start,'DD/MM/YYYY') = date(Finish,'DD/MM/YYYY'), Sum(Number)) does not show the result in the pivot table, and i trying to show the following:

Name	Total Number
Name 1	11

Help!!!!!

Regards !

Re: Add depending on dates

pathiqvd — Tue, 25 Jul 2017 07:43:35 GMT

sum({<Start={"=Start=Finish"}>}Number)

Re: Add depending on dates

arvind_patil — Tue, 25 Jul 2017 07:51:33 GMT

Hi Matias,

Try to load only those data where date(Start) = Date(Finsh) in Script level. And check the Simple Straight table.

Name and Sum(Number)

Thanks ,

Arvind Patil

Re: Add depending on dates

marcus_malinow — Tue, 25 Jul 2017 08:02:54 GMT

Hi Matias,

you could try adding a flag when you load your qvd

if(Start=Finish, 1, 0) as StartEqualsFinish

You can then use this in an expression

sum({$<StartEqualsFinish={'1'}>} Number)

Marcus

Re: Add depending on dates

Kushal_Chawda — Tue, 25 Jul 2017 09:22:46 GMT

may be like this

sum({<Start=p(Finish)>}Number)

Re: Add depending on dates

Anonymous — Tue, 25 Jul 2017 12:54:56 GMT

Thank you very much for yours answers!!!