Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

igorcastelo
New Contributor

How to Erase line by the date of creation

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.

Captura de Tela 2018-05-23 às 09.40.14.png

Tags (1)
1 Solution

Accepted Solutions
eduardo_dimperi
Valued Contributor II

Re: How to Erase line by the date of creation

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;

3 Replies
eduardo_dimperi
Valued Contributor II

Re: How to Erase line by the date of creation

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
New Contributor

Re: How to Erase line by the date of creation

Hey Eduardo,

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

Tks

eduardo_dimperi
Valued Contributor II

Re: How to Erase line by the date of creation

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