Amountnotthesame

master_student — Mon, 22 Aug 2016 10:26:16 GMT

Hello dear community,

I use the same expression in a pivot table and in a text object :

=count( //if(IsNull(MAT)='0',

if(day(date([Date Dern. modif.],'DD/MM/YYYY'))>=day(date(Today()-1,'DD/MM/YYYY'))

and month(date([Date Dern. modif.],'DD/MM/YYYY'))>=month(date(Today()-1,'DD/MM/YYYY'))

and Year(date([Date Dern. modif.],'DD/MM/YYYY'))>=Year(date(Today()-1,'DD/MM/YYYY')),

if(LONG_DESC_STATUS='Fermé crédit'

OR LONG_DESC_STATUS='Fermé-remboursé'

OR LONG_DESC_STATUS='Fermé activation'

OR LONG_DESC_STATUS='Fermé BO'

//OR LONG_DESC_STATUS='Fermé DT'

//OR LONG_DESC_STATUS='Fermé BO-Non Traité'

OR LONG_DESC_STATUS='Fermé BO Non Traité'

OR LONG_DESC_STATUS='Fermé Rétention'

OR LONG_DESC_STATUS='Fermé Rétention Client Perdu'

OR LONG_DESC_STATUS='Fermé Rétention Client Retenu'

OR LONG_DESC_STATUS='Fermé Support VAS'

OR LONG_DESC_STATUS='Fermé – Doublon'

OR LONG_DESC_STATUS='Abandonné'

OR LONG_DESC_STATUS='Fermé Support VAS-Rejeté'

OR LONG_DESC_STATUS='Rejeté',CASE_ID)))

The pb is the amout displayed is not the same in the two graphs :

In the pivot table, I have a condition on a field. probably this condition is causing the gap (supprimer si valeur est nulle est coché)

=if( [Type Acces] = 'Mobile' and [Entité] = 'BO B2C',[Dern. modif par],

if ([Type Acces] ='Fixe' and [Entité] = 'Fixe B2C', [Dern. modif par])

)

I need to have the same number as the pivot table.

Thanks for your help.

topic Amountnotthesame in QlikView