50% data to be considered from records

[Gowtham174]

Hi All,

My requirement is as below please help me to get the 50% of data from the records.

In the attached file i have team leader  and count of the team leader in the i need to consider only 50% of the records.

for example

team leader A as 16 records count, in that i need to consider only 8 records how can i consider only 50% of the count of the records

column C and column D i added to show my requirement output should be.

Please help me.

Thanks,

Gowtham

[Ricardo_Gerhard]

Dear Gowtham,

Try to use SAMPLE

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPre...

[Quy_Nguyen]

Try this with your connection:

Load *, If(NO <= "Count(Team Leader)"/2 , 'Yes', 'No') As Consider;
Load *,
     AutoNumber(RecNo(),"Team Leader") As NO;
LOAD
    "Team Leader",
    "Count(Team Leader)"
FROM [lib://Desktop/Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);