Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III

Values not grouping by field in table

I have not had this issue amongst other reporting, and I'm not sure if it has to do with the date field having a time stamp before I am reformatting it, but let me know what you think. The data is pretty straight forward, but wont roll up under the same Client or Date field...

Capture.PNG

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Yes, i think its due to reformatting internally that date still holding timestamp. Try using format like Floor() or Num() around your dates creating a new field.

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

Yes, i think its due to reformatting internally that date still holding timestamp. Try using format like Floor() or Num() around your dates creating a new field.

MalcolmCICWF
Creator III
Creator III
Author

Ok that's the only think I could think of causing the problem. Good suggestions, let me try that and I'll

report back!

MalcolmCICWF
Creator III
Creator III
Author

That did work, thanks for the suggestion