Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
matbelli
Contributor
Contributor

Count when a word is repeated more than once in a day as one

Hi all, i need to count multiple items in one day as one, i have a table like this:

IdContoNumContoDataCampiModificati
1026834126832406948919/07/2018 17:49:07documento
1026834126832406948919/07/2018 17:50:26cap
1026834126832406948923/07/2018 10:44:01id_tipo_documento
1026834126832406948923/07/2018 10:45:16documento
1026834126832406948923/07/2018 10:45:17documento
1026432526832406948923/07/2018 10:45:18documento
1026834126832406948923/07/2018 10:45:19documento
1026834126832406948923/07/2018 10:45:19documento


I need to count everytime i find "documento" or "id_tipo_documento"and it has to count  2, one for 19/07 and one for 23/07 for IdConto 10268341. How can i do it?

Thanks in advance

3 Replies
uacg0009
Partner - Specialist
Partner - Specialist

Hi Matbelli,
Do you mean you need to :
Count(distinct {<CampiModificati = {"documento","id_tipo_documento"}>}Date(Data,'YYYY-MM-DD'))
Please try.
if your "Data" column is not "Date" type, you can use left() function in it.
Aiolos Zhao
matbelli
Contributor
Contributor
Author

it doesn't work 

uacg0009
Partner - Specialist
Partner - Specialist

in my desktop it worked.
if you don't share a sample, we don't know why it doesn't work
and you even don't say what the result is after you did