topic Expression in Text Object in QlikView

Expression in Text Object

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have two variables v_CurrentFiscalYear and v_CurrentFiscalYearPeriod. Those two are returing correct value is I use these to show only value in Text Object. But I want to show like this:

Fiscal Year = CurrentFiscalYear and Fiscal Month = CurrentFiscalYearPeriod

My expression is like this:

='Fiscal Year =' & ='$(v_CurrentFiscalYear)' & 'and Fiscal Month =' ='$(v_CurrentFiscalYearPeriod)'

But it is throwing error. How to to handle this.

Please help.

Thanks,

Sarif

Re: Expression in Text Object

tresB — Mon, 13 Mar 2017 07:11:32 GMT

Try removing the quotes around variable expansion and removing extra '=' signs, like:

='Fiscal Year =' & $(v_CurrentFiscalYear) & 'and Fiscal Month =' & $(v_CurrentFiscalYearPeriod)

Re: Expression in Text Object

dsharmaqv — Mon, 13 Mar 2017 07:16:17 GMT

Try this

='Fiscal Year = ' & '$(v_CurrentFiscalYear)'

='Fiscal Year = ' & '$(v_CurrentFiscalYearPeriod)'