Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have an interesting question and I hope someone can help me out with this.
I have a field called Location that has the following string values StringValue 1, StringValue 2, StringValue 3.
I would like to create a new field value called StringValue4 based on StringValue1 and StringValue 2 and add it to the original field so that my new field values would be StringValue 1, StringValue 2, StringValue 3 and StringValue 4.
I do not know if this is actually possible, but if it is, I would appreciate help on this.
Thanks
Hi,
Try this way,
Data:
Load
Loaction
From xyz;
load
if(Location = StringValue1,'Matched','Not Matched') as Location
Resident Location;
I hope you got. If not provide the qvw file.
Regards,
Kaushik Solanki
Hi Kaushik,
I do not think that will give me what I am looking for, as that does not create a new field value in the way I require
Just for clarity, this is what I want
Field
StringValue 1
StringValue 2
String Value 3
New Field
StringValue 1
StringValue 2
StringValue 3
StringValue 4
When I now use New Field in a chart dimension, it should return 4 possibilities instead of 3.
Thanks
HI,
Can you tell me how you want your 4th value to be generated.
I mean what calculation you want to do to get 4th value.
Regards,
Kaushik Solanki
If your field 'location' has three field values always, is it possible to load these values in three fields (location-1, location-2, and location-3)?
If that is possible, you can generate the fourth value (as the fourth field, location-4) by left join.
Let me provide some code for clarity.
I have tried this out and it is almost there, but not quite there yet.
IF(Area = 'GA', 'GA',
IF(Area ='F', 'F',
if(Area = 'P', 'P',
if(Location='B' OR Area = 'C' OR Area = 'Comp' OR Area = 'D' OR Area= 'F' OR Area ='GA' OR Area = '','Total'))))
Now the problem is that before the if statements assigns values to Total, the values are already used by GA and F, so the Total value does not give the right Total, but only gives the value for Comp, C, P and B. I want the Total value to be the sum of everything.
How can I get that to work?
Thanks
HI,
What i can understand from this is you want a forth field to have a value "Total" when the area is C/Comp/D/F/GA and location is B.
If this is what you want then you have done the right thing,
If not then please tell me with example what you have and what you desire.
Regards,
Kaushik Solanki