Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rcorcoran
Creator
Creator

header expression

Hi Trying to get a header to show the current year selected -1 ie 2015 if it is 2016 selected.  Any help would be appreciated

='Staff Category Primary Care '& GetFieldSelections((ReferredYYYY)-1)

1 Solution

Accepted Solutions
sunny_talwar

Try this:

='Staff Category Primary Care '& (GetFieldSelections(ReferredYYYY)-1)

or may be this:

='Staff Category Primary Care '& (Max(ReferredYYYY)-1)

View solution in original post

2 Replies
sunny_talwar

Try this:

='Staff Category Primary Care '& (GetFieldSelections(ReferredYYYY)-1)

or may be this:

='Staff Category Primary Care '& (Max(ReferredYYYY)-1)

View solution in original post

rcorcoran
Creator
Creator
Author

Thanks Sunny works a treat