conditional maptips
I want to display the Values based on Condition.
If Category is 'A' then Display Field1,Field2,Field4
else if Category is 'B' then Display Field1, Field3, Field6
else if Category is 'C' then Display Field1,Field3,Field5,Field6.
How can we achieve this functionality in Map tips with GVH5.
0
-
You can do this using a one-to-one data link that uses the CASE expression:
SELECT
CASE
WHEN Category = 'A' THEN Field2
WHEN Category = 'B' THEN Field3
WHEN Category = 'C' THEN Field3
END AS Field2
Same expression, but condensed:
SELECT
CASE
WHEN Category = 'B' OR Category = 'C' THEN Field3
ELSE Field 2
END AS Field20
Please sign in to leave a comment.
Comments
1 comment