topic Re: how to create a dynamic text in qliksense in App Development

how to create a dynamic text in qliksense

gss123 — Thu, 31 Aug 2023 03:51:00 GMT

"Net retail for august 2023(MTD) IS 10% less than august 2022(MTD)" how to write this text by dynamically and which chart should pull for that.

Re: how to create a dynamic text in qliksense

Aurelien_Martinez — Thu, 31 Aug 2023 09:38:05 GMT

Hi,

You can try a expression like:

='Net retail ' & [ExpressionToGiveMonth] & ' IS ' & [ExpressionPercent] & ' ' & If(sign([ExpressionPercent])=1, 'more', 'less') & ' than ' & [ExpressionToGiveMonthN1]

Re: how to create a dynamic text in qliksense

gss123 — Thu, 31 Aug 2023 09:55:24 GMT

need the exact any expression please kindly provide.