
1. Re: Convert SPSS Syntax to Tableau Calculation
Deepak Rai Oct 18, 2018 2:59 PM (in response to Milankumar Patel)What I understand from this is, You want to Create VARMRV Like This, I assume that First Value is always 1
If Var1={MIN(Var1)} Then 1
ELSEIF
Var2={MIN(Var2)} Then 2
ELSEIF
Var3={MIN(Var3)} Then 3
.
.
.
ELSEIF
Var96={MIN(Var96)} Then 96
END
Thanks
Deepak

2. Re: Convert SPSS Syntax to Tableau Calculation
Milankumar Patel Oct 18, 2018 6:36 PM (in response to Deepak Rai)Hi Deepak,
I will give it a try and let you know. How would I give those new values a name?
Regards,
Milan

3. Re: Convert SPSS Syntax to Tableau Calculation
Deepak Rai Oct 18, 2018 10:48 PM (in response to Milankumar Patel)When You Createa New Calculated Field. Name it VARMRV and write above formula

4. Re: Convert SPSS Syntax to Tableau Calculation
Milankumar Patel Oct 21, 2018 9:52 AM (in response to Deepak Rai)Hi Deepak,
When I tried to create the VARMRV using the method said above, The numbers were not matching with SPSS. So I tried a different approch and created 5 different variables in SPSS. 1. Tenure_ALL (having all date periods) 2. Tenure_3m (Less than 3 month) 3. Tenure_6m (Less than 6 month) 4. Tenure_12m (Less than 12 months) 5. Tenure_G12m (More than 12 months).
I want to create a filter like a dropdown list from this 5 variables. Like when Someone select less than 3 month from dropdown, the data displayed on chart will be filtered to display less than 3 month data. just add more info here, chart will be created using different variables, I also want to create a filter using above variables.
I tried creating a parameter first, than created another calculated field aligned to parameter. But I am not able to put it as a filter.
Any help on this will be much appreciated.
Thanks in advance.
Milan