Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Creating a new field value

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

Not applicable

Creating a new field value

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

Highlighted

Creating a new field value

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

nagaiank
Valued Contributor III

Creating a new field value

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

Re: Creating a new field value

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

Creating a new field value

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