Interesting conundrum there--I haven't run into that before. Could you try passing %2C in place of , in the URL string?
This is a great one for the Ideas section, currently it is by design that it is not possible to pass a comma in a URL parameter/filter. However, there is a workaround. Create a calculated field similar to the following:
If FIND([Test], "a") > 0 then
LEFT([Test],FIND([Test], "a", 1)-1)
+ ", " +
Right([Test],FIND([Test], "a", 1)-1)
This calculated field can be used to reinsert a comma into the parameter to replace a placeholder character (in this case, --> “a”). Thus “/views/parameterissue/Sheet1?Test=1a2” returns “1, 2”. Clearly the calculated field above only works if there is one comma, so this solution may not be practical if the data supports an unknowable number of commas. For more information about string functions, see the online help - http://onlinehelp.tableausoftware.com/current/pro/online/en-us/functions_functions_string.html
Hope this helps!
Thanks to you both! I'm anxious to report back on our final solution using Tracy's workaround but I'm having some unrelated Server issues. I believe the workaround will do the trick for us.
5 of 5 people found this helpful
See page 191 of the Tableau Server Administrator Guide - you can pass a comma to a URL filter by escaping it:
2 of 2 people found this helpful
Thanks for hunting that down Alistair. Even these many months later, I only just now found your post of this solution for passing a comma in a url!
Periods are handled similarly; %5C%2E will give an escaped period.
Also, unless your string ENDS in a comma, you will probably have a space after it.
Thus, from Alistair's example, you would actually need One%5C%2C%20Two if you are trying to filter on a string of "One, Two"
And if your string is "One, Two." it would be One%5C%2C%20Two%5C%2E
It was on page 214 of the Server Admin 8.0 manual.
Page 191 of Server Admin 7.0
I have never read the section of the guide on embedding since I was using tabcmd. I was using the PPT slides on URL Parameterization and the Admin Guide tabcmd section and don't recall seeing this explained. Looks like I have more reading to do! Again, thanks!
Nice! This was insanely helpful! I ended up simply doing a similar function using a replace function.