topic Re: Data Manipulation in QlikView

Data Manipulation

Tue, 04 Aug 2015 06:08:59 GMT

Hi,

Please help me with data manipulation.

Attached the Qvw and i have mentioned the requirement.

Regards,

Keerthi KS

Re: Data Manipulation

qlikmsg4u — Tue, 04 Aug 2015 06:21:41 GMT

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'))

Re: Data Manipulation

Tue, 04 Aug 2015 06:25:33 GMT

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

Re: Data Manipulation

qlikmsg4u — Tue, 04 Aug 2015 06:43:15 GMT

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'))

Re: Data Manipulation

Anonymous — Tue, 04 Aug 2015 08:02:26 GMT

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

Re: Data Manipulation

Tue, 04 Aug 2015 08:54:43 GMT

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

Re: Data Manipulation

sasiparupudi1 — Tue, 04 Aug 2015 09:53:08 GMT

Hi Keerthi

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

Sasi

Re: Data Manipulation

Tue, 04 Aug 2015 09:54:11 GMT

Yes in the chart object

Re: Data Manipulation

Wed, 05 Aug 2015 05:51:12 GMT

Any updates on this ?