5 Replies Latest reply on Dec 26, 2013 2:22 AM by Manas Ranjan Kar

    Calculation field , how to convert functions ??

    jabrane.belghith

      Hi every one,

      I worked with Qlikview 11 and I moved to work with tableau software; where I have to do the same work , but with tableau : I have a function that I will convert them to be compatible to a calculated field , the function is : "

       

      =aggr(if(avg(aggr(count(DISTINCT DESTINATAIRE)/Count(DISTINCT if(aggr(Count(POSITION)>0, DOSSIER),DOSSIER)),DOSSIER))>1 and

      avg(aggr(count(DISTINCT EXPEDITEUR)/Count(DISTINCT if(aggr(Count(POSITION)>0, DOSSIER),DOSSIER)),DOSSIER))>1,'Dossier groupage','Dossier complet')

      ,DOSSIER)"