Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master
‎2020-05-01 02:54 AM

How to make my title display from Jan - April 2020 [COMPANY] to 2020 [COMPANY]

Hi All

Below expression Display "Jan - May 2020 [COMPANY]

='Jan - '&SubField('$(MonthNames)', ';', $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year)-0)'}>}month), Num(Month(Today())))))& ' ' & ' ' & max(year) & ' ' &ColumnDim101& ' '

May i know how to make it display 2020 [COMPANY]

i Have try below :-

='Jan - '&SubField('$(MonthNames)', ';', $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year)-0)'}>}month), )))& ' ' & ' ' & max(year) & ' ' &ColumnDim101& ' '

it does not work.

Paul

380 Views
0 Likes
1 Reply
edwin
Master II
Master II
‎2020-09-17 10:26 AM

Im guessing the reason no ones responded to this is bec.  there isnt enough information to work on to even understand why your code is not working.  you are using a lot of columns and at least 1 variable that only you know what it contains.  adding a qvw would be most helpful to enable someone else to help you.

307 Views