Good day everyone, I hope this is a simple question.
I am trying to put together some "persona mapping", and one of the tasks is to find out if a resource/employee has a laptop AND a desktop.
We have Equipment_Type as the device type (either desktop, laptop, tablet, etc) we have Report_Name, which gives us the actual USER IDs.
I have done this in python w/ a simple for x in x type of loop, but i am unable to get this working in Qlik Sense Enterprise for a KPI and/or a table that shows these users w/ both devices.
i have tried: count(if(Equipement_type like '*POSTE*' and Equipement_type like '*PORTABLE*',Report_name)) but this will clearly not work because you will not have a "POSTE" and a "PORTABLE" (sorry it's french) at the same time. Poste = desktop, portable = laptop.
So, in a nutshell, how do we count the number of users who have both a laptop and a desktop assigned to them?
