Help Required to Convert below calculation into dynamic one
Qlik Calculation -(Floor(YearEnd($(vTodaysDate)))-Floor(YearStart($(vTodaysDate)))+1)
Convert into Tableau calculation

Question

Help Required to Convert below calculation into dynamic one Qlik Calculation -(Floor(YearEnd($(vTodaysDate)))-Floor(YearStart($(vTodaysDate)))+1) Convert into Tableau calculation

Vishwarath Nagaraju · Accepted Answer

@Mukul Bajpai​ can you try below expression and let me know if that works? DATEDIFF('day', DATE(DATETRUNC('year', TOday())), DATE(DATETRUNC('year', DATEADD('year',1,Today()))-1))

Vishwarath Nagaraju · Answer

@Mukul Bajpai​ can you close the thread marking the response as select as best so others can benefit from this.

Help Required to Convert below calculation into dynamic one (Floor(YearEnd($(vTodaysDate)))-Floor(YearStart($(vTodaysDate)))+1)

Tableau Desktop & Web Authoring

Formation associée

Aide supplémentaire