Add depending on dates

[Anonymous]

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 !

[pathiqvd]

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

[arvind_patil · Accepted solution]

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

[marcus_malinow]

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

[Kushal_Chawda]

may be like this

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

[Anonymous]

Thank you very much for yours answers!!!