Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
Hey Eduardo,
Tks for the help, i had to use another tools, but your tip help me a lot.
Tks
Not problema, if you need some help dont hesitate to ask