topic AW:String and values in Expression in QlikView

String and values in Expression

Mon, 05 Jul 2010 10:29:50 GMT

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.

AW:String and values in Expression

brenner_martina — Mon, 05 Jul 2010 10:46:45 GMT

Hi, b,

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

vForecast: >= Date1 + <= Date2

AW:String and values in Expression

Mon, 05 Jul 2010 10:57:39 GMT

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.

AW:String and values in Expression

Mon, 05 Jul 2010 11:26:54 GMT

Ok, I managed to do that using the &.