Hello, folks,
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.
