Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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
sum({<Start={"=Start=Finish"}>}Number)
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
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
may be like this
sum({<Start=p(Finish)>}Number)
Thank you very much for yours answers!!!