I have a document that i want to track time parcels are received in quarterly bands, this is simple with power pivot but i have to do it in Qlikview. The issue is its not classifying one of the times its simply ignoring it, I have created a pie chart because i want to show it as a pie chart and clearly one of the slices is random i dont know where it came from. I have looked at the code and it seems its not classifying 08:30 for some reason here is the code and i have attached pictures. If there is a better way please advice me.
Thank you for your reply first thing tanks for clarifying that. My view was not to count non key fields sins they may have null values but not ijn this case since they can not be null so that makes sense. thank you.
Second issue is the solution you gave me earlier in response to my original question did not work. I changed a few arrival times to be bang on the boundary and it gave me wrong chart as before, I changed the following:
I have discovered your solution works well with data loaded Inline. when i load the data from file with Arrival times which are right on the borderline like 08:46, 08:45, 08:16, It fails of which most data will be coming from file not inline. you can try it with the file attached.
