topic Re: String variable in calculated dimension not working in QlikView

String variable in calculated dimension not working

Fri, 17 Aug 2012 13:24:22 GMT

Hello, I'm trying to build a calculated dimension that reflects the directory chosen by the user. It's pretty simple, but it's not working!

Formula is: ='\\T:\ScanDocs\'+$(scanstr) , which produces "Error in calculated dimension"

If I try ='\\T:\ScanDocs\'+'$(scanstr)' , I get NULL

In both cases, I've checked that scanstr is declared and has an actual value.

I've tried this both as an expression and a dimension (would rather it be a dimension, though).

Any idea what I'm doing wrong? In another document, I used this syntax in the LOAD statement, and it worked fine. I'm trying to avoid reloading

every time the user changes the directory he wants to use, as one server is over burdened.

matt_crowther — Fri, 17 Aug 2012 13:28:51 GMT

Try without the '+' sign.

Works for me.

All the best,

Matt - Visual Analytics Ltd

@QlikviewBI

swuehl — Fri, 17 Aug 2012 13:29:16 GMT

Try using the string concatenation operator & if you want to concatenate strings.

Fri, 17 Aug 2012 13:35:23 GMT

Duhh! Forgot that '+' is the concat operator in SQL, not QV! Thanks!!