Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please help me with data manipulation.
Attached the Qvw and i have mentioned the requirement.
Regards,
Keerthi KS
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'))
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
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'))
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
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
Hi Keerthi
Where must it do this calculation? in the chart object?
Sasi
Yes in the chart object
Any updates on this ?