Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a new field value

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

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
nagaiank
Specialist III
Specialist III

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.

Not applicable
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!