Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 &.