Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try without the '+' sign.
Works for me.
All the best,
Matt - Visual Analytics Ltd
Qlikview Design Blog: http://QVDesign.wordpress.com
@QlikviewBI
Try using the string concatenation operator & if you want to concatenate strings.
Duhh! Forgot that '+' is the concat operator in SQL, not QV! Thanks!!