Dynamic Report Header

triekong — Thu, 11 Jan 2018 03:28:20 GMT

hi All,

i am trying to dynamically change the header on my report dynamically based on selections from inside my QV App.

i have a list box, and attemptiing to have the header change based on sales.

GOALS: When no 'Sale Date' selection is made, to have the header say: "Sales for min(SaleDate) to max(SaleDate)"

When a "Sale Date" selection is made, to have the header say: "Sales for selected month"

Problems:

-For the 1st GOAL, i am having trouble adding the 'to max(SaleDate)' part of the formula. Need help with the syntax

-For the 2nd goal, when i select 2 months, i want both months to show up in the header..it should read "Sales for Sale Date selected month1 +selected month2 "

Current Syntax : =( 'Sales for ' & if([Sale Date] = [Sale Date], GetCurrentSelections([Sale Date]), MonthName(min([Sale Date])) ))

thanks!

Re: Dynamic Report Header

jonathandienst — Thu, 11 Jan 2018 04:43:47 GMT

How about something like:

=If(GetPossibleCount(Month) = 1,

'Sales for ' & Month,

'Sales from ' & Date(Min(Date)) & ' to ' & Date(Max(Date))

)

-- assumes that the Month field is dual month value and the date field is a QV numeric date value

topic Re: Dynamic Report Header in QlikView

Dynamic Report Header

Re: Dynamic Report Header