topic Re: Text Object Calculation in QlikView

Text Object Calculation

byrnel0586 — Tue, 14 Jun 2016 19:43:55 GMT

Hi,

I want to create a text box that says: Data Processed From 1/1 of the year prior to the selected year through the max report date of the year prior to selected year. Ex. "Data Processed From 1/1/2016 - 5/31/2016" when 2017 is selected.

I have the first part but am having trouble with the second.

=If(Only(Year),'Data Processed From 1/1/' & (Only(Year)-1))

It doesn't have to be all in one formula, but that would be ideal

Re: Text Object Calculation

Clever_Anjos — Tue, 14 Jun 2016 20:04:14 GMT

Maybe

='Data Processed From ' & YearStart(Min(Date)) & ' - ' & YearEnd(Max(Date))

I´m guessing you have a field called Date

Re: Text Object Calculation

sunny_talwar — Tue, 14 Jun 2016 20:04:39 GMT

May be this:

=If(Only(Year),'Data Processed From ' & Date(YearStart(Date, -1), 'M/D/YYYY') & '-' & Date(AddYears(Max(Date), -1), 'M/D/YYYY')

Re: Text Object Calculation

byrnel0586 — Tue, 14 Jun 2016 20:18:06 GMT

Thank you. It's called ReportDate, but I am needing the year prior to the year that is selected to show.

Re: Text Object Calculation

byrnel0586 — Tue, 14 Jun 2016 20:21:53 GMT

Thanks again, Sunny!!

Re: Text Object Calculation

sunny_talwar — Tue, 14 Jun 2016 20:32:13 GMT

No problem at all