topic Re: filling the data in QlikView

filling the data

Wed, 16 Dec 2015 06:12:39 GMT

Hi Friends,

I have the below source file including the below 2 fields Level1 and Level2, using these two fields i have to get the COA field.

the conditions are:

1) if level 2 is having data that should reflect in the COA field,

2) if level 2 is null then it has to consider level1 data in the COA field

3) if the two fields are blank it has to take the above of that data

Is this possible to do in Qlikview?

Please help me....

Level1

Level2

COA

Vehicle Loans	Vehicle Loans - Fixed Rate	Vehicle Loans - Fixed Rate
		Vehicle Loans - Fixed Rate
		Vehicle Loans - Fixed Rate
Vehicle Loans - Variable Rate	Vehicle Loans - Variable Rate	Vehicle Loans - Variable Rate
		Vehicle Loans - Variable Rate
Personal Loans	Personal Loans - Fixed Rate	Personal Loans - Fixed Rate
		Personal Loans - Fixed Rate
		Personal Loans - Fixed Rate
Personal Loans		Personal Loans
		Personal Loans

Re: filling the data

tresB — Wed, 16 Dec 2015 06:17:47 GMT

Try like:

If( Len(Trim(COA))=0, Peek(COA), COA) as NewCOA

Re: filling the data

Wed, 16 Dec 2015 06:17:56 GMT

Yes.

For first two requirements,

if( length(level2)>0,level2,

if(length(level2)=0,level1)) as COA

For third requirement can you please share sample qvw?

thanks

Khushboo

Re: filling the data

marcus_sommer — Wed, 16 Dec 2015 06:18:50 GMT

This could be solved with Peek() or Previous() ?

- Marcus

Re: filling the data

Anonymous — Wed, 16 Dec 2015 06:20:30 GMT

may be this at script:

=if(Level2<>null() or Level2<>'', Level2, IF(Level1='' or Level2='', Previous(Level1)) as COA

Re: filling the data

Wed, 16 Dec 2015 06:22:38 GMT

Dear Tresesco,

thank you for the quick reply.

i do not have a field COA, i have to create with existing fields.

any other idea?

Re: filling the data

jagan — Wed, 16 Dec 2015 06:26:26 GMT

HI,

Try like this

LOAD

If( Len(Trim(Level2))> 0, Level2, Level1) as COA

FROM DataSource;

Hope this helps you.

Regards,

jagan.

Re: filling the data

tresB — Wed, 16 Dec 2015 06:35:00 GMT

Missed some points.

Try:

If(Len(Trim(Level2))=0, If(Len(Trim(Level1))=0, Peek(Level2), Level1), Level2) as COA

Re: filling the data

Wed, 16 Dec 2015 10:36:47 GMT

Hi friends,

i completed the requirement with you people help,

Facing an issue here that,

if u see my attachment, some of the values are not visible in my chart but they are populating in the list box.

what might be the issue?

Re: filling the data

Anonymous — Wed, 16 Dec 2015 10:43:57 GMT

Could you post some sample data?