Data Manipulation

[#1]

Hi,

Please help me with data manipulation.

Attached the Qvw and i have mentioned the requirement.

Regards,

Keerthi KS

[qlikmsg4u]

HI Try this

=If(Level1 = 'Undefined',If(Left(Assignment,4)=Level1Code1,Level1,'Undefined'))

but it seems there is no corresponding values in Level1Code1 in Assignment

replacing above with this it working

=If(Level1 = 'Undefined',If(Left(Assignment,4)=Inflow_Assignment,Inflow_Assignment,'Undefined'))

[#3]

Well. Requirement is If its in Undefined and If the  first 4 numbers of Inflow_assignment matches the Level1Code1 then it has to Display Corresponding Level1

[qlikmsg4u]

then try this, but any way you get Undefined only. Better to check requirement once again

=If(Level1 = 'Undefined',If(Left(Assignment,4)=Inflow_Assignment,Level1,'Undefined'))

[Anonymous]

Keerthi ,

I think your requirement is

if Level1 = 'Undefined' then it should return undefined else it will check with if(left(Inflow_Assignment,4)=Level1Code1 then it should return you Level1 (once again confirm your requirement)

in that case you need to write your expression as

if (Level1 ='Undefined','Undefined',if(left(Inflow_Assignment,4)=Level1Code1,Level1,'Undefined' ))

you can move your (left(Inflow_Assignment,4) to script side

like left(Inflow_Assignment,4)  as NewColumnName then use this column in UI expression.

Thanks

BKC

[#6]

Requirement is If Level1='Undefined' then it has to check for the value left(Inflow_Assignment,4).

If the left(Inflow_Assignment,4) = Level1Code1 . If its equal then it has to fetch corresponding value from Level1.

Otherwise it should be Undefined.

Let me know if u need any other details

[sasiparupudi1]

Hi Keerthi

Where must it do this calculation? in the chart object?

Sasi

[#8]

Yes in the chart object

[#9]

Any updates on this ?