Skip to main content

Qlik

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
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ 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: 
DanTrousdale
Contributor
Contributor
‎2019-10-09 05:45 AM

Combining String, Formulas, and Variables in Cell

Hi,

What I'm trying to do is combine Formulas and Variables and String within a cell.

The desired output would be:

Total Enrolments for 2019 as of 09 October 2019: 11,111.

To give you more context the expression I'm currently attempting and failing at is:

="Total Enrolments for" & <Variable> & "as of" & <Variable> & ":" & <Formula>

Thanks in Advance,

Dan

Labels (1)
Labels
525 Views
0 Likes
2 Replies
DanTrousdale
Contributor
Contributor
‎2019-10-09 05:49 AM
Author

Additional context, I'm creating an Excel Report.

522 Views
0 Likes
Ruggero_Piccoli
Support
Support
‎2019-10-09 08:43 AM

Hi,

Try by developing the formula in the source QVW and only after copy and paste it in the Formula node of the template. 

Refresh also the connection cache. 

When you are asking info about errors please also post screenshots of the error and the log files, etc. We need to read at least the error message.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
496 Views