2 Replies Latest reply on Nov 1, 2018 12:17 PM by Venkat S

Create multi-category field from same value(s)

Venkat S Nov 1, 2018 12:03 PM

Hi All,

I am trying to create product groups but unable to create same.

I tried using both CASE and IF functions but both giving same result.

Here is case script:

CASE [Product]

WHEN "Product A" THEN "Group 1"

WHEN "Product A" THEN "Group 2"

WHEN "Product B" THEN "Group 1"

WHEN "Product B" THEN "Group 2"

WHEN "Product C" THEN "Group 1"

WHEN "Product C" THEN "Group 2"

WHEN "Product D" THEN "Group 1"

WHEN "Product D" THEN "Group 2"

END

Thank you!

1. Re: Create

Deepak Rai Nov 1, 2018 12:04 PM (in response to Venkat S)

How can you add One product to 2 groups. I would like to learn.
Like Show 1 Likes(1)

Actions
2. Re: Create multi-category field from same value(s)

Venkat S Nov 1, 2018 12:17 PM (in response to Deepak Rai)

My Bad above is wrong example. Basically I am want to analyze combine effect of different product combinations
Here is case script:
CASE [Product]
WHEN "Product A" THEN "Comb A+B+C"
WHEN "Product B" THEN "Comb A+B+C"
WHEN "Product C" THEN "Comb A+B+C"
WHEN "Product B" THEN "Comb B+C+D"
WHEN "Product C" THEN "Comb B+C+D"
WHEN "Product D" THEN "Comb B+C+D"
WHEN "Product C" THEN "Comb C+D+E"
WHEN "Product D" THEN "Comb C+D+E"
WHEN "Product E" THEN "Comb C+D+E"
END
Like Show 0 Likes(0)

Actions

Tableau Community Forums