Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String variable in calculated dimension not working

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

3 Replies
matt_crowther
Luminary Alumni
Luminary Alumni

Try without the '+' sign.

Works for me.

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

@QlikviewBI

swuehl
MVP
MVP

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

Not applicable
Author

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