Get employee data

[bhuprakash]

Dear All,

I am sharing 2 tables with you one is Complete SIO data and other is Activity Done by.

I need Territory Sales Head Code and Territory Sales Head Name in the third sheet who have not done the activity.

Pls Pls help me in the same. Appreciate your quick revert.

[giovanneb]

Hello, use the function where not exists

example

load

TSHName

resident ChannelInventory

where not exists (TSHName, TSH);

[bhuprakash]

Hi Giovanne,

I am a beginner to the qlik so it will be great if you can do it in my file.

Thanks in advance.

[vishsaggi]

Not sure if this what you are looking for try below

Add straight table then add calculated dimension like

= Aggr(IF(Not Match(Dist_TSH, [Territory Sales Head Name]), [Territory Sales Head Name]), [Territory Sales Head Code])

Expr: Give [Terriroty Sales Head Code]

[bhuprakash]

Hi Vishwarath,

Thanks for replying me.

Your result is giving 37 employee information but if you check there are 233 employee in Complete SIO data and out of these 33 have not done activity then result should come for 200 employees but it is coming for 37 only. Please check the same again.

[bhuprakash]

sorry 33 have done the activity so 200 not done any activity so data should come for 200 employees

[vishsaggi]

May be because your Dist_TSH and [Territory Sales Head Name] has different case values. I mean few values are Upper case and few values are Lower case hence its unable to match with the names. Convert them to upper case and check. Like

UPPER(Dist_TSH) AS Dist_TSH

do this in your table where ever you have this field. And same for below

UPPER([Territory Sales Head Name]) AS [Territory Sales Head Name]

Then run and let me know.