Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String and values in Expression

Hi all,

I'd like to write in an Expression a value and a fixed string, something like this:

Only({<ReceivedDate={'$(vForecast1)'}>}FinalLabel + ' to ' + Only({<ReceivedDate={'$(vForecast2)'}>}FinalLabel

Is there a way to do it? Thanks a lot for your help.

1 Solution

Accepted Solutions
Not applicable
Author

Ok, I managed to do that using the &.

View solution in original post

3 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi, b,

plaese give us the example of your varialbes vForecast1 and vForecast2, you can define a variable with both conditions:

vForecast: >= Date1 + <= Date2

Not applicable
Author

Hi Martina,

thanks for your answer.

The variable vForecast1 and vForecast2 contain dates selected in two listboxes and the formula Only({<ReceivedDate={'$(vForecast1)'}>}FinalLabel) return the shipping mode for the selected date. What I'm trying to do is showing how the shipping mode changes from one forecast to another one. I need to show something like this: "Sea to Land", "Sea to Air" and so on.

Do you a way to do that? Thanks.

Not applicable
Author

Ok, I managed to do that using the &.