the boss need me to add another field named SamePersonOrNot
In my try is :
I split the row 1 isornotsequece with ',' and got the 1st value is 63232
then I want to use 63232 to find in this table's field number and find it row get the name is jane
but I have not a method to support me to do like this.I use fieldIndex('name','63232') in the actual table from a qvd file. but I got the wrong name ....
the lookup function is not allowed to use in the chart.
please help out to stop my boss kill me .thank you all.
Easy breezy just use the Qlik Previous function to compare if any value is the same on the previous row, as it is on this row. You want to have the data sorted in order to use this kind of approach
IF(Name = Previous(Name), 'Yes', 'No') as SamePersonOrNotFlag
I'm not exactly sure what you are trying to do just throwing that out there.
If you are just looking to figure out how to add a new field to your INLINE data you can do a preceding LOAD with inline statements just like other forms of data loading. That really comes in handy when you want to convert date values etc, or create flags with DUAL function:
Easy breezy just use the Qlik Previous function to compare if any value is the same on the previous row, as it is on this row. You want to have the data sorted in order to use this kind of approach
IF(Name = Previous(Name), 'Yes', 'No') as SamePersonOrNotFlag
I'm not exactly sure what you are trying to do just throwing that out there.
If you are just looking to figure out how to add a new field to your INLINE data you can do a preceding LOAD with inline statements just like other forms of data loading. That really comes in handy when you want to convert date values etc, or create flags with DUAL function:
