Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
triekong
Creator
Creator

Dynamic Report Header

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!

1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein