How to Erase line by the date of creation

[igorcastelo]

Hi people, im new here and i have this situation:i have a table with the calls that my chat team made in a month, but if a cliente enters in the chat more than once, each new conversation create a new line in the report. I want to consider only the first chat and erase the other ones, how can i do this in the script of qlik sense? This picture below can explain more about the situation. Tks people.

[eduardo_dimperio · Accepted solution]

Hi Igor,

In Chart you can use [CHAT START] as measure and get Min value, like Min[CHAT START]

In script the same thing

Load

CLIENT

MAX [CHAT START]

RESIDENT YOURTABLE

GROUP BY

CLIENT;

[igorcastelo]

Hey Eduardo,

Tks for the help, i had to use another tools, but your tip help me a lot.

Tks

[eduardo_dimperio]

Not problema, if you need some help dont hesitate to ask