topic Re: Classifying nulls in a field based on another field in QlikView

Classifying nulls in a field based on another field

Anonymous — Thu, 07 Apr 2016 09:08:43 GMT

Hi All,

Please any help will be appreciated.

I am trying to Classify nulls in a field based on another field with below script:

LOAD
Rank,
If(Match(Rank, '1','2', '3'),'VP',
If(Match(Rank, '4', '5'),'Dir',
If(Match(Rank, '6','7'),'Mgrs',
If(Match(Rank, '8', '9','10'),'Prof',
if(Match(EMP_TYP,'Reg','Temp ') and Rank = 'UNDEFINED','Undefined Emp',
if(Match(EMP_TYP,'CW') and Rank = 'UNDEFINED','Undefined CWs','UNDEFINED')))))) as [RANK DESC]
Resident EmployeeData;

Unsuccessful, because its taking all nulls count for each classification, instead of count for each classification.

Thanks & Regards

Neetha

Re: Classifying nulls in a field based on another field

kaushiknsolanki — Thu, 07 Apr 2016 09:12:32 GMT

Hi Neetha,

Can you please explain with example. Like what you want and what you are getting. Sample file will be a good help

Regards,

Kaushik Solanki

Re: Classifying nulls in a field based on another field

kkkumar82 — Thu, 07 Apr 2016 09:15:21 GMT

Can you put some sample data here so that it will be easy for us.

As far as your condition you should get "undefined" if all conditions are false.

Kiran Kumar

Re: Classifying nulls in a field based on another field

Kushal_Chawda — Thu, 07 Apr 2016 09:16:05 GMT

Can you display what you are getting right now and what is expected?

Re: Classifying nulls in a field based on another field

Anonymous — Thu, 07 Apr 2016 13:02:18 GMT

Hi All,

Please see sample data and application.

above script is working fine for sample data, but not for the real data.

Expected result for real data:

[Undefined Emp] count : 6

[Undefined CWs] count : 6

Actual result for real data:

[Undefined Emp] count : 12

[Undefined CWs] count : 12

For sample data it is working and for real data its not working.

why could that be?

Re: Classifying nulls in a field based on another field

Anonymous — Thu, 07 Apr 2016 13:15:30 GMT

It works fine for your qvw & xls as far as I can see - see attached.

Maybe I am is understanding something.

Re: Classifying nulls in a field based on another field

Anonymous — Thu, 07 Apr 2016 13:25:02 GMT

Hi Bill,

It works fine for my qvw & xls.

but the same logic for real data it's not working.

sample data is replicated exactly.

Thanks

Neetha

Re: Classifying nulls in a field based on another field

Anonymous — Thu, 07 Apr 2016 13:26:56 GMT

Without being able to see the issue it is impossible to guess what is happening.

Re: Classifying nulls in a field based on another field

Anonymous — Thu, 07 Apr 2016 13:38:37 GMT

Hi Bill,

I can't post real data

Thanks for trying to help.

Regards

Neetha

Re: Classifying nulls in a field based on another field

Anonymous — Thu, 07 Apr 2016 13:51:32 GMT

Hi Neetha ,

Are there blank values also in the real data????

if so, first handle it as follows:

if(len(trim(Rank))=0,'Undefined',Rank) as RANK and

same for EMP_TYP.

Then use this in your [RANK DESC] for nested if conditions....

Regards

Nitin

Re: Classifying nulls in a field based on another field

florentina_doga — Thu, 07 Apr 2016 13:51:46 GMT

add a field in load like

recno() as no_