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 Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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: 
gss123
Contributor
Contributor
‎2023-08-30 11:51 PM

how to create a dynamic text in qliksense

"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.

Labels (2)
Labels
652 Views
0 Likes
2 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II
‎2023-08-31 05:38 AM

Hi,

 

You can try a expression like:

 

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

 

 

Help users find answers! Don't forget to mark a solution that worked for you!
608 Views
gss123
Contributor
Contributor
‎2023-08-31 05:55 AM
Author

In response to Aurelien_Martinez

need the exact any expression please kindly provide.

 

604 Views
0 Likes