Discussion Board for collaboration related to QlikView App Development.
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.
Try using the string concatenation operator & if you want to concatenate strings.
View solution in original post
Try without the '+' sign.
Works for me.
All the best,
Matt - Visual Analytics Ltd
Qlikview Design Blog: http://QVDesign.wordpress.com
Duhh! Forgot that '+' is the concat operator in SQL, not QV! Thanks!!