The past few months I have been using QlikSense. I have to make conditions for drawing up a KPI.
My example: First I have the order database, I want to count it by means of a count or count distinct. The field would then be OrderID. I want to count this by means of the Complaint Subject. So: Complaint Subject 1 = Count Distinct orderID Complaint subject 2 = Count OrderID Complaint subject 3 = Count Distinct orderID Complaint subject 4 = Count Distinct orderID Etcetera, there's more... The total of all these complaints must be totalized as a number of complaints. In the form of a field In addition, I try to process these in the script and not in the front end of the app. Does anyone know a solution? I hope everything is so clear, if anyone needs more information I'd like to hear it.
