topic Combining String, Formulas, and Variables in Cell in Qlik NPrinting

Combining String, Formulas, and Variables in Cell

DanTrousdale — Wed, 09 Oct 2019 09:45:35 GMT

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

DanTrousdale — Wed, 09 Oct 2019 09:49:05 GMT

Additional context, I'm creating an Excel Report.

Ruggero_Piccoli — Wed, 09 Oct 2019 12:43:27 GMT

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