topic Re: Get employee data in QlikView

Get employee data

bhuprakash — Tue, 22 May 2018 16:55:01 GMT

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.

Re: Get employee data

giovanneb — Tue, 22 May 2018 17:26:59 GMT

Hello, use the function where not exists

example

load

TSHName

resident ChannelInventory

where not exists (TSHName, TSH);

Re: Get employee data

bhuprakash — Tue, 22 May 2018 17:34:38 GMT

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.

Re: Get employee data

vishsaggi — Tue, 22 May 2018 18:17:01 GMT

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]

Re: Get employee data

bhuprakash — Wed, 23 May 2018 05:30:17 GMT

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.

Re: Get employee data

bhuprakash — Wed, 23 May 2018 05:34:29 GMT

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

Re: Get employee data

vishsaggi — Wed, 23 May 2018 14:08:32 GMT

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.